Re: Forms

To 'ignore' any error message, use the ON-ERROR trigger (form-level).
In the trigger body, you can get the error type,error code and error text by using the built-ins ERROR_TYPE; ERROR_CODE, and ERROR_TEXT; You can ignore certain ones by using NULL; as below:

• ON-ERROR trigger (Form-level) DECLARE ERR_TYPE VARCHAR2(10) := ERROR_TYPE; -- This is FRM, ORA, etc. ERR_CODE NUMBER(3) := ERROR_CODE; -- This is the code # ERR_TEXT VARCHAR2(400) := ERROR_TEXT; -- This is the text displayed BEGIN IF (ERR_TYPE='FRM' AND ERR_CODE IN (40405,40401,40402)) THEN NULL; --Null simply does nothing. ELSE
  • This is what normally happen to errors. MESSAGE(ERR_TYPE||'-'||TO_CHAR(ERR_CODE)||': '||ERR_TEXT); RAISE FORM_TRIGGER_FAILURE; END IF; END;

Barry Etter
Oracle Programmer/Analyst
Unifi, Inc. Received on Sun Jan 19 1997 - 00:00:00 CET