Oracle
1Z0-151 · Question #15
1Z0-151 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-151 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
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?
Options
- AYou must handle database errors in an exception clause of the trigger.
- BYou must test for FORM_FAILURE when testing for failure of a stored procedure.
- CYou must test for FORM_FATAL when testing for failure of a stored procedure.
- DFORM_SUCCESS tests for failure of Forms built-ins, not stored procedures.
- EYou cannot test for failure of a stored procedure, because database errors are transparent to Forms.
Unlock 1Z0-151 to see the answer
You've previewed enough free 1Z0-151 questions. Unlock 1Z0-151 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.