You are developing a form that uses alerts to display database message rather than associated FRM messages when the SQL statements issued by the form cause database errors to occur. You use a generic alert called DB_Alert to display the messages.
You begin to code an On-Error trigger to trap the FRM-40505 error that occurs when the SQL statement references an invalid column name. The associated database message is "ORA-00904: Invalid column name", and this is what you want to be displayed in the alert.
You create a form-level On-Error trigger with the following code:
DECLARE
n Number
BEGIN
IF ERROR_CODE = 40505 THEN
SET_ALERT_PROPERTY(‘DB_Alert’,ALERT_MESSAGE_TEXT,
DBMS_ERROR_CODE);
n: = SHOW_ALERT(‘DB_Alert’);
END IF;
END
You run the form to test it.
What will the run-time behavior be when the FRM-40505 error code is encountered?
A.
The alert called DB_Alert appears with the message "ORA-00904: Invalid column name".
B.
The alert called DB_Alert appears, but not with the correct message.
C.
The alert does not appear, and the FRM-40505 message appears in the message line.
D.
The alert does not appear, and the message "ORA-00904: Invalid column name" appears on the message line.
E.
The alert does not appear, and the message "FRM-41039: Invalid Alert ID 0" appears on the message line.
I run this code and got the message “FRM-41039:Invalid Alert ID 0” appears on message line i.e option E.Please tell me the Solution.