Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we use Global Temporary Tables in OIC

Sriram H IyerJul 14 2020 — edited Jul 15 2020

We are running an integration where the SQL Statement being executed is dependent on data existing in a Global Temporary table. However, the 2 actions are being done in different steps and select statement is unable to see the rows in the GTT.

Is it possible to use GTT in OIC? If so, how can we use it?

Comments
Post Details
Added on Jul 14 2020
1 comment
882 views