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!
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
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.