Post Query Trigger In Forms 12c Hangs If Exception Form_trigger_failure Is Used - Works in 10g Forms
Last updated on FEBRUARY 02, 2018
Applies to:Oracle Forms - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 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
WHEN OTHERS THEN
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 18.104.22.168 that it did in 10g forms.
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 hundreds of Community platforms