My Oracle Support Banner

Post Query Trigger In Forms 12c Hangs If Exception Form_trigger_failure Is Used - Works in 10g Forms (Doc ID 2356724.1)

Last updated on FEBRUARY 02, 2018

Applies to:

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


On : Forms

In the POST-QUERY trigger, based on certain condition we are raising exception form_trigger_failure to prevent form from displaying record in data block.

WHEN form_trigger_failure THEN
RAISE form_trigger_failure;
<some code>
RAISE form_trigger_failure;

This trigger works on forms 10g by after migrating to forms 12c same trigger has stopped working.
Form session hangs and only option is to kill the session.

EXPECTED BEHAVIOR: The form_trigger_failure should behave the same way in that it did in 10g forms.


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.