oracle apex GTT preserve rows after logout

577 Views Asked by At

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 ?

1

There are 1 best solutions below

0
On

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