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 11, 2022

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, 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.


Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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