Database Networking (MOSC)

MOSC Banner

Can an Oracle error stack be suppressed when raising an exception?

edited Nov 5, 2016 5:00AM in Database Networking (MOSC) 1 commentAnswered

We currently provide a custom error number and message when application encounters Oracle data not found error.   This produces the custom error number, error message, package name, stored procedure and line number.  Security guidelines specify that only the oracle error number and error message can be displayed.   We are using collections so an Oracle exception has to be raised.  We have tried just providing text but the calling application cannot view text when displaying the error number via dbms_output.  Is there any way to suppress the error stack to only provide the customer error number and message when raising an

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center