is it possible to reset the forms error codes to NULL?
I need this or another idea because we have some user defined exceptions in e.g. INSERT-PROCEDURE which raise ora-20001 or ora20002....
In every Form we have an ON-ERROR-TRIGGER where we catch errors.
IF DBMS_ERROR_CODE BETWEEN -20999 AND -20000 THEN
-- call our "normal" error handling"
The Problem is if there was an ora-20001 error and the next error is frm-xxxxx it shows message because ORA error hasn't changed. Is it possible to reset the ora and frm error codes or is there another possibility to identify the source (ora /frm) of the last error?