Can an Oracle error stack be suppressed when raising an exception?
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