Does a rollback take place if the trigger falls?

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under
certain conditions. Does a rollback take place if the trigger falls?

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under
certain conditions. Does a rollback take place if the trigger falls?

A.
Yes. Although the update has been applied to the database, the old column values are retained
as rollback data; so a failure of this trigger automatically reinstates the original values.

B.
No. It is too late to perform a rollback at this stage because the update has already been
applied.

C.
The value have already been applied, so you must programmatically save the old valuesinthe
global variables or PL/SQL variables if you want to reinstall the original values.

Explanation:
The record has already been updated.
Note: FORM_FAILURE
Returns a value that indicates the outcome of the action most recently
performed during the current Runform session.
Use FORM_FAILURE to test the outcome of a built–in to determine
further processing within any trigger. To get the correct results, you
must perform the test immediately after the action executes. That is,
another action should not occur prior to the test.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Padmanabhan

Padmanabhan

Answer A is Correct

jan

jan

You are correct 🙂

ngayathri81

ngayathri81

A is correct answer