0

I have a GTT in my oracle apex application.

  CREATE GLOBAL TEMPORARY TABLE "SEARCH" 
   (    "CODE" VARCHAR2(15 BYTE), 
    "HEAD" VARCHAR2(100 BYTE), 
    "BRCODE" VARCHAR2(3 BYTE)
   ) ON COMMIT PRESERVE ROWS ;

But the GTT preserves it's rows even after the user log out from the application. If another user login to the application, he can access the same data created by the previous user. What might be the problem with GTT or session ?

Nidheesh
  • 802
  • 1
  • 21
  • 44
  • See here - https://community.oracle.com/thread/2331603 – RLOG Oct 06 '17 at 08:07
  • Thank you @RLOG . – Nidheesh Oct 06 '17 at 09:13
  • @RLOG then if I'm using GTT with "on commit delete rows", can another user access the data before executing commit statement ? – Nidheesh Oct 06 '17 at 09:47
  • I don't think so, but you should test it. If you are using the data from the tables in your APEX application rather than as part of a background plsql task then it would likely be better to use APEX Collections. – RLOG Oct 06 '17 at 10:11
  • ya I too felt apex collection better than GTT in this case . anyway thanks a lot RLOG – Nidheesh Oct 06 '17 at 10:45

1 Answers1

0

Please read this answer thread from oracle community. GTT - Global Temporary Table - Problem with Apex

Nidheesh
  • 802
  • 1
  • 21
  • 44