from:"sangelillis"

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

2003-01-22 Thread sangelillis

 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:



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

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

2003-01-22 Thread sangelillis

 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:



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

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

2003-01-21 Thread sangelillis

 ID:   21773
 User updated by:  [EMAIL PROTECTED]
 Reported By:  [EMAIL PROTECTED]
-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] [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



[2003-01-20 10:19:01] [EMAIL PROTECTED]

This is not an infinite loop, it runs only while ($error==0).

And then there's a time limit for every PHP script, see
.

Better ask such questions in the php.db mailing list, see
.



[2003-01-20 10:01:14] [EMAIL PROTECTED]

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

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

2003-01-20 Thread sangelillis

 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:

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


Previous Comments:


[2003-01-20 10:19:01] [EMAIL PROTECTED]

This is not an infinite loop, it runs only while ($error==0).

And then there's a time limit for every PHP script, see
.

Better ask such questions in the php.db mailing list, see
.



[2003-01-20 10:01:14] [EMAIL PROTECTED]

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

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

2003-01-20 Thread sangelillis

 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:

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


Previous Comments:


[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



[2003-01-20 10:19:01] [EMAIL PROTECTED]

This is not an infinite loop, it runs only while ($error==0).

And then there's a time limit for every PHP script, see
.

Better ask such questions in the php.db mailing list, see
.



[2003-01-20 10:01:14] [EMAIL PROTECTED]

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

#21773 [NEW]: The process is killed after OCIFetch()

2003-01-20 Thread sangelillis

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

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

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

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

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

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

#21773 [NEW]: The process is killed after OCIFetch()

6 matches

Site Navigation

Mail list logo

Footer information