Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error handling in reports

Status
Not open for further replies.

kmuthu

Programmer
Jun 14, 2001
10
US
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.

Thanx in advance
Muthu
 
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);

Hope this helps..
- G.Sharma
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top