#21773 [Fbk->Opn]: The process is killed after OCIFetch()

ID: 21773 User updated by: sangelillis@abacosystem.it Reported By: sangelillis@abacosystem.it -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] iliaa@php.net Do you see "OCI8 Recursive call!" such an error message? ------------------------------------------------------------------------ [2003-01-20 10:51:56] sangelillis@abacosystem.it 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] sangelillis@abacosystem.it 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] michael.mauch@gmx.de 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] sangelillis@abacosystem.it 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