Home/Questions/Q 5520
In Process
Bánhalmi Martin
Bánhalmi Martin

Bánhalmi Martin

View Profile
  • 1
Contributor
Asked: 2021-02-22T19:18:46+05:30

How to use GTT in Oracle Apex?

  • 1

Hi!

I would like to ask, how to use Global Temporary Table in Oracle Apex? Can I somehow manage to give each user a separate database session?

Our current system works mostly with temp tables and we want to switch to Oracle Apex.

Thanks in advance!

 

oracle apex

    1 Answer

    1. Vinish

      Vinish

      View Profile
      Legendary

      You can use the Global temporary table in Oracle Apex as you were using in your old system. But between pages, if you experience issues because internal sessions got changed in Apex, you can use the normal table with two more columns to handle Apex user-wise. Below is an example:

      Add two more columns apex_user and apex_session, to your normal table. Write a process on the login page (9999) to delete the current user's data. Now, whenever you insert or update, you will update the apex_user and the apex_session with your Oracle Apex session-id (:app_session). And use these criteria to read and write the data in the whole application.

      • 0

    You must login to add an answer.