I do not have a clear pix of everything that's going on in you
application, but it sounds to me that you want to pass oracle error code
from the Exception in your proc. Oracle does not store the errors
anywhere in system table automatically for you. If necessary, you can
create your own table to store error codes, but I don't think that is as
useful as what I suggested first.

-----Original Message-----
From: Russ Moser
[mailto:oracledba-ezmlmshield-x46746928.[Email address protected]
Sent: Wednesday, March 01, 2006 3:26 PM
To: LazyDBA Discussion
Subject: Returning error messages

Hello!

I'm running web pages through the apache web server to run plsql
procedures.
I'm trying to enhance the ability of our mod plsql cartridge to return
the error messages
from the database.

Does anyone know of a way to query the database via SQL and determine
the specifics of any error content after an error occurs in a session.

I've looked at some of the objects containing '%ERROR%' but that really
only
addresses current object errors.

Another example. When your in sql and receive an error, sql
communicates back to
you the circumstances of the error. How does this work. I would like
to reproduce
this in the mod plsql cartridge.

Thanks for your time in advance!

Russ



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.


Oracle LazyDBA home page