php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2961 Oracle 8 error handling functions does not work
Submitted: 1999-12-12 16:06 UTC Modified: 2006-07-17 08:55 UTC
From: k_a_h_l_i_l at yahoo dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 3.0.12 OS: RH Linux 6.0
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: k_a_h_l_i_l at yahoo dot com
New email:
PHP Version: OS:

 

 [1999-12-12 16:06 UTC] k_a_h_l_i_l at yahoo dot com
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);
      $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
                      

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-12-28 04:58 UTC] thies at cvs dot php dot net
ocierror return an array!

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 10:01:29 2024 UTC