Forum Stats

  • 3,752,275 Users
  • 2,250,483 Discussions
  • 7,867,774 Comments

Discussions

Oracle 12c forms - Error - FRM-40405

SANPAT
SANPAT Member Posts: 1,072 Silver Badge

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

Tagged: