Hi,
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
messsage(DBMS_ERROR_TEXT);
RAISE FORM_TRIGGER_FAILURE;
ELSE
-- call our "normal" error handling"
ERROR_HANDLING(var.STEP);
END IF;
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?
Regards
Rudi Zugreif
] 
Blog
Search
Help
Members
Register
Login
Home
