yash_08031983 wrote:HI yash,
as by default ctl_shift+e is use to display error.
i want to display " display error" on on-error trigger .
is it possible.
i generaly use on key-others trigger
null; statement to avoid all the extra action associated with keys.
which also restrict the use of ctl_shift_e fucntion.
i want when i press ctl+shift+e display error will execute despite using null; on key-others trigger;
yash_08031983 wrote:Hi yash
you explain the different approaches but i want that particular which i described.
as you said catch the error code but some time procedure declare on form raised some error and in that procedure which sql statement raise the exception, its quite difficult to find. for this you have any trick.
Hope it's help
sql statement ......... EXCEPTION WHEN NO_DATA_FOUND THEN raise_application_error(-20000,'Failed to send mail due to Approve band data not found. ' || sqlerrm); --Band not set or higher authority.
You have to additionally check DBMS_ERROR_CODE for db-errors.
EXCEPTION When No_Data_Found THEN NULL; When Others THEN Message ('OTHERS' || SQLCODE || ' And ' || SQLERRM); Message ('OTHERS' || SQLCODE || ' And ' || SQLERRM); END;