Re: [PHP4BETA] How to handle Oracle Error Messsages?

Hello David, On 02-Mar-00 19:57:15, you wrote: >Ok, I found the php.ini settings that would eliminate the display of the >error messages on the page and the $php_errormsg is being set, so I can >use that. However, I am not having much luck with OCIError(). When I >don't supply the connection handle, it is returning zero, even though my >error log is clearly showing an Oracle generated error. When I try to >supply the connection handle, I get: >PHP Warning: Supplied argument is not a valid OCI8-Connection resource >in /dcis >/apache_bld_1.3.6/htdocs/dag/doquery.php3 on line 62 When the error happens in the context of a parsed statement, you should pass the parsed statement handle to OCIError instead of the connection handle. If you would like to see an example of where each type of handle should be passed to OCIError, look here for this DBMS independent package to interface with databases named Metabase that comes with a OCI driver that you may see how it is done: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --