[phplib] Problem with phplib7.2c and Oracle... From: Christian Erhardt (c.erhardt <email protected>)
Date: 09/27/00

Hi folks,

I have two questions / comments about db_oci8.inc...

1. With Oracle 8.1.6 I get no error-codes in

line 92 $errno=OCIError($this->Parse);

Could I configure Oracle to deliver error codes to php?

b.t.w.: here is a bug in line 93:

instead of "if ($errno == 1403)"
it should be: if($errno["code"] == 1403)

I didn't check all classes if they work correctly when error-codes are
always empty,
do you know more about it?

2.
if ($db -> next_record) returns false, the method disconnect() is called...
Is this the proper way to handle with Oracle?

Instead of using OCILogOff after each select statement I think it's better
to call OCIFreeStatement to free memory.
I've written my own method freestmt() to be called if next_record returns
false.

    function freestmt() {
      if($this->Debug) {
          printf("Free Memory...<br>\n");
      }
      OCIFreeStatement($this->Parse);
    }

What do you think about it?

Thanks for comments and hints,

Christian 

--
Christian Erhardt	                 21TORR AGENCY GmbH
email: c.erhardt <email protected>        Heinestrasse 72
tel: +49-7121-348-245              D-72762 Reutlingen
fax: +49-7121-348-249              http://www.21torr.com

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