Hi, I am accessing an oracle database from PHP using
stored procedures available.
I'd like to detect when a problem occurs in order to
stop trying to fetch results. In mysql I check for
rc=0 as an error. The php doc does not tell if this
applies to oracle as well.
The code is something like this
$res = OCINewCursor($oraCon);
$stm = OCIParse ( $oraCon, "
BEGIN
MY_PROCEDURE(:LOGIN, :PASS, :KEY, :INITIAL, :FINAL,
:RES);
END;
");
OCIBindByName ( $stm, ":LOGIN", &$login, -1);
OCIBindByName ( $stm, ":PASS", &$pass, -1);
OCIBindByName ( $stm, ":KEY", &$key, -1);
OCIBindByName ( $stm, ":INITIAL", &$initial, -1);
OCIBindByName ( $stm, ":FINAL", &$final, -1);
OCIBindByName ( $stm, ":RES", &$res, -1, OCI_B_CURSOR
);
$rc = @OCIExecute ( $stm );
if($rc)
{
OCIExecute ($res);
...
}
else
{
// Error do something!
}
Thanks.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
PHP General 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]
