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 [EMAIL PROTECTED]
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
