Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

View the Exhibit.

To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update of customer_id:
BEGIN
If :old.customer_id != : new.customer_id then
RAISE_APPLICATION_ERROR (-20101, ‘Database trigger says no!’); end if;
END;
You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.
Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?
A. IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF
B. IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM);
END IF;
C. IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;
D. IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM);
END IF;
E. IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;
F. IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM);
END IF;

Download Printable PDF. VALID exam to help you PASS.