#21773 [Opn->Csd]: The process is killed after OCIFetch()
ID: 21773
User updated by: sangelillis@abacosystem.it
Reported By: sangelillis@abacosystem.it
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: Solaris 2.8
PHP Version: 4.3.0
New Comment:
The error has been found, the function OCIFetch() is not responsible
but the function echo in the cycle while it causes an error from the
moment that after the run of the
script the shell is closed.
Thank you and sorry for all.
Previous Comments:
------------------------------------------------------------------------
[2003-01-22 03:44:10] sangelillis@abacosystem.it
I have tried without @ but the visualization of any errors is not had,
the process falls without leaving anybody trace.
The following version of the script is more complete:
<?php
set_time_limit(0);
ini_set('display_errors','0');
ini_set('log_errors','1');
//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);
OCILogoff($dbConnection);
?>
Thank for any suggestion
------------------------------------------------------------------------
[2003-01-21 17:18:05] michael.mauch@gmx.de
Can you please try without these @ signs? If you don't like the
errors/warnings being displayed on your webpages, you can turn
display_errors off and log_errors on, so you can find the
errors/warnings in your log file.
ini_set('display_errors','0');
ini_set('log_errors','1');
------------------------------------------------------------------------
[2003-01-21 03:19:26] sangelillis@abacosystem.it
I don't receive any error or I don't perhaps succeed in capturing it.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/21773
--
Edit this bug report at http://bugs.php.net/?id=21773&edit=1
Thread (9 messages)