Hi,
Is there anyway to show a customised message whenever a standard oracle error occurs while running the report? for eg. i want to display a message whenever there is an error ORA-00904.
Check the help topic: "Defining the error message using SRW.MESSAGE" in reports:
In PL/SQL, you can define an error message and raise it in Report Builder message region with a PL/SQL packaged procedure, SRW.MESSAGE. (Note: You can also define and raise errors within the user exit program. For more information, see Raising errors from the user exit.
SRW.MESSAGE has the following syntax:
SRW.MESSAGE (msg_number NUMBER, msg_text CHAR);
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.