How to select global temp table data in another program
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.