ID: 21773 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Solaris 2.8 PHP Version: 4.3.0 New Comment:
Do you see "OCI8 Recursive call!" such an error message? Previous Comments: ------------------------------------------------------------------------ [2003-01-20 10:51:56] [EMAIL PROTECTED] Before the connection to the db it is present the following statement: //Set max execution time to infinite set_time_limit(0); The loop is stopped when there is an error, in this case the variable $error=1. Thanks ------------------------------------------------------------------------ [2003-01-20 10:51:54] [EMAIL PROTECTED] Before the connection to the db it is present the following statement: //Set max execution time to infinite set_time_limit(0); The loop is stopped when there is an error, in this case the variable $error=1. Thanks ------------------------------------------------------------------------ [2003-01-20 10:19:01] [EMAIL PROTECTED] 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>. ------------------------------------------------------------------------ [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
