On-Error Trigger

If you write NULL in on-error trigger defined in Form level of Forms 10g, then what will happen to the error message during runtime? Will the error message get displayed or not?

Subashpanda
Profile Answers by Subashpanda Questions by Subashpanda
Feb 7th, 2011
2
6671

Questions by Subashpanda answers by Subashpanda

D2K

Answer

Showing Answers 1 - 2 of 2 Answers

Nithin

Jul 24th, 2011

Nothing Happens... the on-error trigger wont be handled in case a NULL is written in the trigger

praduman jha

Dec 10th, 2011

Dear All,

Basically when we write null on on error then at that time, no error will display.

At the backend when we want to search the on which packages are firing then write down ON_ERROR trigger.
DISP_ALERT(DBMS_ERROR_TEXT);
DISP_ALERT(DBMS_ERROR_LINE);

AND COMMENT THE NULL;
we can use this for oracle 10g form only