Error Handling from Packages [message #181477] |
Mon, 10 July 2006 05:14 |
oralover
Messages: 97 Registered: January 2005
|
Member |
|
|
hi all gurus!
i am using forms 6i and 10g, database is 9i(4.0.2).
i created a stored package which have some procedures and functions, i am calling some procedures/functions from one button in Form, if any procedure/function generate error how i can trap efficiently with knowing which procedure/function generated this error???
thanks for help.
|
|
|
Re: Error Handling from Packages [message #182366 is a reply to message #181477] |
Fri, 14 July 2006 08:22 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Look at dbms_error_code and error_code. You will probably have to raise an error in the exception processing part of your package's procedure or function. Get the Forms reference manual and search the example code.
David
|
|
|