Exhibit:
You are coding a trigger (shown in the exhibit) to display the database error that occurs when users encounter the FRM-40505 error about being unable to execute a query. You have created an alert called Ouery_Alert. For the FRM-40505 error, the trigger should display the database error message in the Ouery_Alert. For all other errors, the trigger should display default messages on the console message line.
Examine the code for the On-Error trigger. When you attempt to compile this trigger, you receive a compilation error with the message “Error 215 at line2, column 4: String length constraints must be in range (1..32767)”.
What corrections should you make so that the trigger compiles and functions properly?
A.
Eliminate the n variable because SHOW_ALERT does not return a value
B.
Change the n variable to a NUMBER data type and change SLQERRM to DBMS_ERROR_TEXT.
C.
Change the n variable to a NUMBER data type, replace SHOW_ALERT with FIND_ALERT, and change the line beginning with SET_ALERT _PROPERTY to SET_ALERT _MESSAGE _PROPERTY(‘Ouery _Alert’ ,SQLERRM);
D.
Change all occurrences of error_code, error_type, and error_text to message_code, message_type and message_txt.