From: [EMAIL PROTECTED] Operating system: Suse Linux 8.0 PHP version: 4.2.3 PHP Bug Type: OCI8 related Bug description: Hang during ociexecute
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 bug report at http://bugs.php.net/?id=21491&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21491&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21491&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21491&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21491&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21491&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21491&r=support Expected behavior: http://bugs.php.net/fix.php?id=21491&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21491&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21491&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21491&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21491&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21491&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21491&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21491&r=gnused