PL/SQL (MOSC)

MOSC Banner

How to select global temp table data in another program

edited May 26, 2020 4:04PM in PL/SQL (MOSC) 7 commentsAnswered ✓

We are unable to select gtt in another program but with in the same session.

I have created a GTT table with On commit preserve rows.

We have created an XYZ procedure to see insert record_id to the GTT table based on some business logic. In the same procedure, we are launching another ABC program using find_request.sumbmit().

The ABC program should generate an outbound file-based GTT record ids. But the GTT has no records.

When we do debug before submitting the ABC program the GTT table has records.

We submitting ABC program within same session still GTT returning no records. How we can achieve the requirement. The purpose we are using GTT table is same program is submitted by multiple dept's with different files. So, to generate outbound files specific to session-level we have used the concept of GTT but it is not working.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center