Good afternoon, all.  Sorry if this has been covered before, but a search
of the archives doesn't turn up any relevant answers.

I'm having a problem with the OCI8 commands.  I'm using PHP 4.0.4pl1 with
Oracle 8.0.5 (yes, I know that's old, but somebody seems to have lost the
CD for 8.1...).  Consider the following code where OCIExecute returns
false and PHP spits out the wrning message
        Warning: OCIStmtExecute: ORA-00001: unique constraint (CUSTOM.SYS_C007900) 
violated ORA-06512: at "CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 
in db.php on line 344

        $s = OCIParse($conn, $query)
        $rc = OCIExecute($s, OCI_COMMIT_ON_SUCCESS);
        if(!$rc) {
          $err = OCIError($statement);

          if(!$err) {
            $err = OCIError($this->conn);

            if(!$err) {
              $err = OCIError();

              if(!$err) {
                print("OCIExecute() returned false, but can't find an error\n");
              } else {
                print("error elsewhere\n");

            } else {
              print("error in connection\n");
          } else {
            print("error in statement\n");

I always end up with "OCIExecute() returned false, but can't find an
error".  I can, of course, suppress the PHP error by preceding OCIExecute
with an @, but that doesn't fix the problem:  I can't programmatically
retrieve the error.

Am I missing something, or is the OCI8 support just badly broken?


B r i a n  L a l o r                         [EMAIL PROTECTED]     Spam me not.
   To get my pgp key, put "get pgp key" in the subject of your message

Asking a pilot what he thinks about the FAA is like asking a fireplug what
it thinks about a dog.

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to