Re: Bug #2961: Oracle 8 error handling functions does not work

On 12 Dec 1999 k_a_h_l_i_l@yahoo.com wrote: > From: k_a_h_l_i_l@yahoo.com > Operating system: RH Linux 6.0 > PHP version: 3.0.12 > PHP Bug Type: Oracle related > Bug description: Oracle 8 error handling functions does not work > > Setup: RH Linux 6.0/Oracle EE 8.1.5/Apache 1.3.9/PHP 3.012 > Script to reproduce problem: > ---------(start code) > $stmt = "insert into... values..."; //will raise a unique constraint violation > error > $stmt = ociparse($conn, $stmt); > @ociexecute($stmt); > $err1 = ocierror(); > $err2 = ocierror($stmt); the error happened on the statement-level so $err = ocierror($stmt); var_dump($err); will show you the "right" error. plz close the bug report yourself after verifying. thanx, tc > $err3 = ocierror($conn); > print "Error > messages:<br>(1)".$err1."<br>(2)".$err2."<br>(3)".$err3."<br>"; > print "PHP error: ".$php_errormsg; > ---------(end code) > > This will output (when viewed in HTML browser): > ---------(start output) > (1) > (2)Array > (3) > PHP error: OCIStmtExecute: ORA-00001: unique constraint (WEEZ.SYS_C00894) violated > ---------(end output) > > Notice that the ocierror() function is totally useless in this example. > > Other probably irrelevant info: > PHP cofigure line: configure --with-apxs=... --with-apache=... --with-oracle=... --with-xml > > php.ini file: > include_path=... > auto_prepend_file=... > track_vars = on > magic_quotes_gpc = on > sendmail_path /usr/sbin/sendmail -t > track_errors = on > short_open_tag = off > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany