Exhibit:
You are implementing a search function for employees that relies on the fact that the PREVIOUS_RECORD built-in fails when the cursor is in the first record. The code for the Search button is shown in the exhibit is:
IF :control.search_text IS NOT NULL THEN
GO_BLOCK(‘Employees’);
LAST_RECORD;
WHILE :employees.last_name != :control.search_text LOOP
PREVIOUS_RECORD
IF NOT FORM_SUCCESS then
MESSAGE(‘Employees not found’);
RAISE FORM_TRIGGER_FAILURE;
END IF;
END LOOP;
MESSAGE(The requested employee has been found!’);
END IF;
You do not want users to see the alert shown in the exhibit. FRM-40100 is the least severe type of error message.
Which line(s) of code placed just prior to the PREVIOUS_RECORD built-in in this trigger will achieve this, while allowing more severe messages to be displayed?
A.
IF DMBS_ERROR_CODE = 40100 THEN
NULL;
END IF;
B.
IF ERROR_CODE = 40100 THEN
NULL;
END IF;
C.
IF MESSAGE_CODE = 40100 THEN
NULL;
END IF;
D.
SYSTEM.MESSAGE_LEVEL:= ‘0’;
E.
SYSTEM.MESSAGE_LEVEL:= ‘5’;
F.
SYSTEM.MESSAGE_LEVEL:= ’25’;