From:             [EMAIL PROTECTED]
Operating system: Solaris 2.8
PHP version:      4.3.0
PHP Bug Type:     OCI8 related
Bug description:  The process is killed after OCIFetch()

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 bug report at http://bugs.php.net/?id=21773&edit=1
-- 
Try a CVS snapshot:         http://bugs.php.net/fix.php?id=21773&r=trysnapshot
Fixed in CVS:               http://bugs.php.net/fix.php?id=21773&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=21773&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=21773&r=needtrace
Try newer version:          http://bugs.php.net/fix.php?id=21773&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=21773&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=21773&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=21773&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=21773&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=21773&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21773&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=21773&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=21773&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=21773&r=gnused

Reply via email to