ID: 21773 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: OCI8 related Operating System: Solaris 2.8 PHP Version: 4.3.0 New Comment:
This is not an infinite loop, it runs only while ($error==0). And then there's a time limit for every PHP script, see <http://www.php.net/manual/en/function.set-time-limit.php>. Better ask such questions in the php.db mailing list, see <http://www.php.net/mailing-lists.php>. Previous Comments: ------------------------------------------------------------------------ [2003-01-20 10:01:14] [EMAIL PROTECTED] 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 this bug report at http://bugs.php.net/?id=21773&edit=1