Re: Bug #1665: Can't logon and execute SQL statements on an identified database instance !

Try this: <?php putenv("ORACLE_SID=orcl"); /* or whatever your ORACLE_SID is */ putenv("ORACLE_HOME=/u01/app/oracle/product/8.0.5"); /* or whatever your ORACLE_HOME is */ $conn = ocilogon("user","user_pass","ORACLE_SID"); $stmt = ociparse($conn, "delete from testeoci"); ociexecute($stmt); ocilogoff($conn); ?> If this works, then you probably need to get the Oracle environment set up correctly for the user that apache runs under...I set it up so that all users get the Oracle environment variables set at login. Mark Britton mbritton@verinet.com ----- Original Message ----- From: <wsb@dc.ufscar.br> To: <php-dev@lists.php.net> Sent: Monday, July 05, 1999 2:20 PM Subject: [PHP-DEV] Bug #1665: Can't logon and execute SQL statements on an identified database instance ! > From: wsb@dc.ufscar.br > Operating system: Linux RedHat 5.2 and 6.0 > PHP version: 3.0.11 > PHP Bug Type: Oracle related > Bug description: Can't logon and execute SQL statements on an identified database instance ! > > > Hi Folks, > > I made two simple php3 files just to delete all data in a table called "testeoci" in an Oracle 8.0.5 database instance. Both work fine when i call them using the shell prompt but neither work when i call it via a Web Browser ! My Web Server is an Apache 1.3.6 and my PHP version is 3.0.11. Apache is running as "apache" user and i run the files on the same account as apache user ). I can't figure out what could be wrong since all the variables are correctly set. Maybe it is really a bug ! > > The files code are listed bellow : > > file://Test file #1 > > <?php > > $conn = ocilogon("user","user_pass","ORACLE_SID"); > > $stmt = ociparse($conn, "delete from testeoci"); > ociexecute($stmt); > ocilogoff($conn); > > ?> > > > file://Test file #2 > > <?php > > $conn = ora_logon("user@ORACLE_SID", "user_pass"); > $cursor = ora_open($conn); > ora_parse($cursor, "delete from testeoci"); > ora_exec($cursor); > ora_logoff($conn); > > ?> > > Notes : 1 - Everything seems okay with oracle 'cause i can connect with the related database using the sqlplus program. So, the files 'tnsnames.ora' and 'listener.ora' are ok ! > 2 - I have a web site running php3 scripts which connects successfully with an Oracle database, but they use the regular logon statement (which works fine !) : $conn = ora_logon("user@hostname", "user_pass"); > 3 - I've tested it over RedHat 5.2 and 6.0 producing the same results ! > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net