My Oracle Support Banner

Exception In When-Validate-Record Does Not Propagates To Parent Block (Doc ID 251975.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

 You have a When-Validate-Record trigger which raises Form_Trigger_Failure. This trigger is executed via a When-Button-Pressed trigger which basically does a Next_Record (which implicitly fires the When-Validate-Record). However, the When-Validate-Record trigger can raise a Form_Trigger_Failure but is not handled in this trigger. Therefore, normal exception rules is that the exception is handled by the parent block (in this case the When-Button-Pressed trigger) which has the exception handler. However, you find that upon returning to the Parent block, the exception is not handled and the process executes the next line of code. Why ?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.