Skip to Main Content

APEX

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!

Using Global Temp Table in apex

pkpandaMay 23 2018 — edited May 23 2018

Hi All

I just want bit of a information of using Global Temp Table in apex.

Is it recommended to use global temp table which is populated by a process when a page is submitted and then query from the GTT to display in the same page using IR report.

As I know GTT is session base and apex use multiple session for single request/response.

I know I can use collection but the question is about GTT, can this be used in apex same as PL/SQL or not .

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2018
Added on May 23 2018
5 comments
5,298 views