ID: 21773
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
I don't receive any error or I don't perhaps succeed in capturing it.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
