ID: 21491 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Feedback Bug Type: OCI8 related Operating System: Suse Linux 8.0 PHP Version: 4.2.3 New Comment:
Does it help if you 'do it by the book', <http://www.php.net/manual/en/ref.oci8.php>, i.e. don't use putenv() or Apache's SetEnv, but set the environment variables before you start Apache? And did you check whether your Apache is linked to pthread (see the page mentioned above)? Previous Comments: ------------------------------------------------------------------------ [2003-01-07 09:32:33] [EMAIL PROTECTED] Works fine on Solaris in DSO and CGI. You might want to test the connection to see if it happened and call OCIError as well. ------------------------------------------------------------------------ [2003-01-07 08:19:04] [EMAIL PROTECTED] I'm trying to get some (existing) records oput of an Oracle8-Database. As long as I do a query, which can't have any results, everything works fine. But if I write a SELECT-statement, which should give at least one result, the whole thing hangs or I get the message 'The page cannot be displayed'. example (which causes me troubles): <?php putenv('ORACLE_HOME=/opt/oracle/OraHome1'); putenv('TNS_ADMIN=/opt/oracle/OraHome1/network/admin'); putenv('TWO_TASK=/opt/oracle/OraHome1/network/admin/tnsnames.ora'); $user=""; $pwd=""; $conn = ocilogon($user,$pwd,"TNEUN2"); $sql="select * from t_person WHERE name like 'Muster' ORDER BY name, firstname, notes, racf"; $stmt=ociparse($conn,$sql); ociexecute($stmt); echo $sql; ?> The 'echo-statement' is only used to verify that the script has finished! The statement "select max(id_pers) from t_person" for example works fine. Thanks in advance! Greetings Stephan ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21491&edit=1
