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 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.2.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.

EXCEPTION
WHEN form_trigger_failure THEN
RAISE form_trigger_failure;
WHEN OTHERS THEN
<some code>
RAISE form_trigger_failure;
END;

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 12.2.1.2 that it did in 10g forms.


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.