|
Re: On-Error vs On-Message [message #81908 is a reply to message #81902] |
Mon, 31 March 2003 23:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
utsav
Messages: 94 Registered: March 2003
|
Member |
|
|
Hi,
These are the two triggers which are used to trap any erroors or messages that will be diaplyed.
Write these triggers on the form level, because if u have these triggers on form level and any level below it, form level will be executed.
Whenever there is an error of frm or ora type onerrors will be fired. To trap the error the err_code and err_text.
Whenever and message is displayes like, transaction complete or n records displayed, on message trigger wll be fired, use message_code and message_text to trap these.
U can also use message_level to suppress the messages as u like
In case of problems do let me know.
utsav.
|
|
|