You have a form that called a database stored procedure. You do not want processing to continue, so immediately after th

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You have a form that called a database stored procedure. You do not want processing to continue, so immediately after th

Post by answerhappygod »

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?

A. You must handle database errors in an exception clause of the trigger.
B. You must test for FORM_FAILURE when testing for failure of a stored procedure.
C. You must test for FORM_FATAL when testing for failure of a stored procedure.
D. FORM_SUCCESS tests for failure of Forms built-ins, not stored procedures. E. You cannot test for failure of a stored procedure, because database errors are transparent to Forms.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply