dear Friends
Whenever i update or add the record gets the message as FRM-40405, tried all the options to supress this error.
the following code added in ON-ERROR, ON-MESSAGE, but still receive the message.
IF ERROR_TYPE = 'FRM' AND ERROR_CODE = 40405 THEN NULL;
ELSE
MESSAGE(ERROR_TYPE||'-'||ERROR_CODE||': '||ERROR_TEXT);
RAISE FORM_TRIGGER_FAILURE;
END IF;
Please suggest how to supress this error.
Sanjay