Home » Developer & Programmer » Forms » How to reset error codes (Forms 10)
How to reset error codes [message #540639] Wed, 25 January 2012 01:44
Gogetter
Messages: 34
Registered: December 2009
Location: Cologne Germany
Member
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
Previous Topic: how to set lov search value
Next Topic: various beginner forms questions [merged 3 by jd]
Goto Forum:
  


Current Time: Wed Oct 22 19:12:13 CDT 2014

Total time taken to generate the page: 0.08626 seconds