From: [EMAIL PROTECTED] Operating system: Solaris 2.8 PHP version: 4.3.0 PHP Bug Type: OCI8 related Bug description: The process is killed after OCIFetch()
Hello, we have a PHP script that run in a infinite loop looking on ORACLE DB (8.1.7). In each loop a SELECT is done, if this doesn't return data then the SELECT is executed after two seconds. If after not certain time the SELECT doesn't return data then when it returns data the process is killed after OCIFetch(), view code for understand better. //START $dbConnection = @OCILogon(USER_ID, PASSWORD, SID); // infinite loop $error=0; do { $query="SELECT DATA FROM PROV"; $stmt = @OCIParse($dbConnection,$query); @OCIDefineByName($stmt,"DATA",&$data); @OCIExecute($stmt); $err_ora = @OCIError($stmt); if ($err_ora) { $error=1; } While (@OCIFetch($stmt) && ($error==0)) { .... .... } @OCIFreeStatement($stmt); sleep(2); }while ($error==0); Thanks for any suggestion -- Edit bug report at http://bugs.php.net/?id=21773&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21773&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21773&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21773&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21773&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21773&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21773&r=support Expected behavior: http://bugs.php.net/fix.php?id=21773&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21773&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21773&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21773&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21773&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21773&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21773&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21773&r=gnused