From: tomek at matrox dot pl Operating system: W2k, Red Hat PHP version: 5.0.0 PHP Bug Type: OCI8 related Bug description: OCi reports OCIStmtExecute: ORA-24324: service handle not initialized
Description: ------------ I wrote my site using PHP 4.3.8, W2k and Apache in both version 2 and 1.3.x. Everything was all right until the day when I decided to change my php version (now I have 5.0.0) Scripts which executes oracle queries sometimes works sometimes not. I've notice 2 kinds of situations: First : apache reports : Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324: service handle not initialized in /usr/local/apache/htdocs/dupa1.php on line 5 Second : apache child process is killed I thought that problem is in OS. I tried to run my site on Red Hat with apache 1.3.31 and php 5.0.0 and problem is still the same. Changes in version of Oracle client also doesn't resolve the problem. Reproduce code: --------------- $query = 'SELECT * FROM opal_sesje'; $conn = ocilogon('xxx','xxx','xxx'); $stmt = OCIParse($conn, $query); OCIexecute($stmt, OCI_DEFAULT); $error = OCIError($stmt); print_r($error); Expected result: ---------------- just blank page Actual result: -------------- blank page or OCI warning or no result -- Edit bug report at http://bugs.php.net/?id=29608&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29608&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29608&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29608&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29608&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29608&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29608&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29608&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=29608&r=support Expected behavior: http://bugs.php.net/fix.php?id=29608&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=29608&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=29608&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29608&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29608&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29608&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29608&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=29608&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29608&r=float