Exhibit:
You are developing an Order Entry form. The When-New-Form-Instance trigger executes a query on the only block in the form. Instead of the alert shown in the exhibit, when the query cannot be performed you want to display to the user a message with the actual database error that is received.
What can you do to implement this?
A.
In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in:
IF NOT FORM _SUCCESS THEN
message(DBMS_ERROR_TEXT);
END IF;
B.
In the When-New-Form-Instance trigger, insert this code after the EXECUTE_QUERY built in:
IF NOT FORM_SUCCESS THEN
message(SQLERRM);
END IF;
C.
Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN
message(DBMS_ERROR_TEXT);
END IF;
D.
Place this code in a form-level On-Error trigger:
IF ERROR_CODE = 40505 THEN
message(SQLERRM);
END IF;
E.
Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(DBMS_ERROR_TEXT);
F.
Add this exception handler to the When-New-Form-Instance trigger:
EXCEPTION
WHEN ERROR_CODE = 40505 THEN
MESSAGE(SQLERRM);