OCI8 error problems
| From: | Brian Lalor | Date: | Wed, 14 Feb 2001 22:40:02 +0000 |
| Subject: | OCI8 error problems | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6646@lists.php.net to get a copy of this message | ||
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");
print_r($err);
}
} else {
print("error in connection\n");
print_r($err);
}
} else {
print("error in statement\n");
print_r($err);
}
}
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?
Thanks,
B
_____________________________________________________________________________
B r i a n L a l o r blalor@hcirisc.cs.binghamton.edu
http://hcirisc.cs.binghamton.edu/~blalor
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.