[phplib] db_oci8 next_record() and disconnect() From: Mikhail Avrekh (ami <email protected>)
Date: 07/07/00

Hello,

Maybe someone who uses Oracle 8 has come across the same problem. In
db_oci8.inc there is the following code :

          $errno=OCIError($this->Parse);
          if(1403 == $errno) { # 1043 means no more records found
              $this->Error="";
              $this->disconnect();
              $stat=0;
           } else {
                ...get the record....
        }

However, it seems like the disconnect() doesn't happen when the last row
is reached, and since my document uses many queries to various tables, the
"max cursors exceeded" error comes up eventually. The error code for "last
record reached" is ORA-01403 -- should I maybe compare $errno to this
whole string ?

Also - how come disconnect() calls ocilogoff() and not
ocifreestatement() ? The latter would seem like a more logical choice, in
order not to have to re-establish connections for every query...

Thanks !

M.

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>