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 : //Test file #1 <?php $conn = ocilogon("user","user_pass","ORACLE_SID"); $stmt = ociparse($conn, "delete from testeoci"); ociexecute($stmt); ocilogoff($conn); ?> //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 !