Re: PHP 4.0.6 with Oracle 8i - Blank screen

On Tue, Jan 22, 2002 at 09:19:07AM -0500, Atif_Jakupovic@hc-sc.gc.ca wrote: > > > Hi, > I configure PHP with Oracle "-with-oci8=". > Everything looks fine, but when I try to logon and create a table I got a blank > page, and my table was not created. > > The script that I was using is below: > |-------------------------------------------------------------------------| > |<?php | > |print "<HTML><PRE>"; > | > |putenv("ORACLE_HOME=/apps/oracle/v8.1.6"); | > |putenv("ORACLE_SID=DEV1"); | > |putenv("TNS_ADMIN=/apps/oracle/v8.1.6/network/admin"); | > |$db = "BCAD6_DEV1"; | > | | > | | > | | > |$c1 = ocilogon("nssadm","nssadm",$db); > | > |$c2 = ocilogon("nssadm","nssadm",$db); > | > | | > |function create_table($conn) | > |{ $stmt = ociparse($conn,"create table nssadm.hallo( test | > |varchar2(64))"); | > | ociexecute($stmt); | > | echo $conn." created table\n\n"; | > |} | > | | > |function commit($conn) | > |{ ocicommit($conn); | > | echo $conn." commited\n\n"; | > |} | > |print "</PRE></HTML>"; > | > |?> | > |-------------------------------------------------------------------------| > > > > > > Does somebody know what I'm missing here? not calling create_table in your script? tc