I thought I'd ask this in the Oracle group. Does Oracle have a way of
returning exceptions thrown to STDERR for a PHP script to capture and
work with?

Short of returning the error in a cursor or as a function value, is
there any way to capture the error that Oracle may throw? Our app
team is asking this.

On Jan 26, 7:35*am, ExecMan <artme... (AT) yahoo (DOT) com> wrote:
It depends; you could read here:

http://oratips-ddf.blogspot.com/2008...-is-human.html

and see if this answers your question.


David Fitzjarrell

On Jan 26, 10:19*am, ddf <orat... (AT) msn (DOT) com> wrote:

Not quiet. I'm looking to see if there is something like OCI_ERROR
where I can capture this from the application end......

On Thu, 26 Jan 2012 06:35:30 -0800, ExecMan wrote:

It depends on the framework you're using to work with Oracle. If you're
using the native OCI8 framework, which is procedural in nature, you have
to throw exceptions yourself, for every error that occurs.
If, on the other hand, you are using ADOdb, it has facilities to throw
exceptions which can be caught like this:
try {
$db->Connect($DSN['database'], $DSN['username'], $DSN['password']);
if (!empty($AFILE)) {
$rs = $db->Execute($AFILE);
}
$rs = $db->Execute($FILE, array('TBLSPC' => $TBLSPC));
csr2html($rs, ' ');
$db->close();
}
catch(Exception $e) {
die($e->getMessage());
}

That will catch any possible error during the connection phase, as well as
the errors in SQL execution. ADOdb can be downloaded from here:

http://adodb.sourceforge.net/

--
http://mgogala.freehostia.com