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 MAY 11, 2016

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

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