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 MAY 31, 2023

Applies to:

Symptoms

On : 12.2.1.2.0 Forms

In the POST-QUERY trigger, based on certain condition, the exception form_trigger_failure is raised to prevent a form from displaying a record in a 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, but after migrating to Forms 12c, the same trigger has stopped working.
Form session hangs and the only option is to kill the session.

EXPECTED BEHAVIOR: The form_trigger_failure should behave the same way in 12.2.1.2 as it did in 10g Forms.

Cause

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