ID:               21773
 User updated by:  [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
 Status:           Open
 Bug Type:         OCI8 related
 Operating System: Solaris 2.8
 PHP Version:      4.3.0
 New Comment:

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


Previous Comments:
------------------------------------------------------------------------

[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

------------------------------------------------------------------------

[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

------------------------------------------------------------------------

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

Reply via email to