Valid 1z0-151 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-151 Exam! ExamDiscuss.com now offer the newest 1z0-151 exam dumps, the ExamDiscuss.com 1z0-151 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-151 dumps with Test Engine here:
You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code: IF NOT FORM_SUCCESS THEN MESSAGE ('Stored Procedure failure'); RAISE FORM_TRIGGER_FAILURE; END IF; You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
Correct Answer: A,D
Explanation/Reference: Explanation: A: You should use DBMS_ERROR_CODE and DBMS_ERROR_TEXT in an ON-ERROR trigger to trap errors propagated from Oracle server from Forms. Note: FORM_SUCCESS and FORM_TRIGGER_FAILURE Either the FORM_SUCCESS built-in or the FORM_TRIGGER_FAILURE exception must be used to handle all Forms errors. FORM_SUCCESS is a Boolean function that evaluates to TRUE or FALSE depending on the success or failure of a Forms built-in. FORM_TRIGGER_FAILURE is an exception that has to be raised to stop further processing whenever an error occurs or FORM_SUCCESS evaluates to FALSE. The following sections describe their use in error-message handling.