ID: 21773 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Solaris 2.8 PHP Version: 4.3.0 New Comment:
I don't receive any error or I don't perhaps succeed in capturing it. Previous Comments: ------------------------------------------------------------------------ [2003-01-20 14:52:10] [EMAIL PROTECTED] Do you see "OCI8 Recursive call!" such an error message? ------------------------------------------------------------------------ [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
