My Oracle Support Banner

Global Temporary Table not Keeping Records when Navigating from One Form to Another Via OPEN_FORM Built-in (Doc ID 2134046.1)

Last updated on JULY 31, 2019

Applies to:

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

Symptoms

Using the database feature of Global Temporary Tables (GTT) in a Forms application with the option of ON COMMIT PRESERVE ROWS.  The GTT is populated  with Form A.  OPEN_FORM with the SESSION option is used to open
Form B. From Form B,  the records in the GTT are not available when queried.

 

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
Cause
Solution


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