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 !