plsqloracle12cjdbc-odbc

Global temporary table clears on commit

CREATE GLOBAL TEMPORARY TABLE "TEMP_TABLE"
   (    
    COLUMNS...

   ) ON COMMIT PRESERVE ROWS ;

I am calling the global temp table from java jdbc innser sql

Global temporary table clears on commit which is not expected

Solution

  • The transaction getting complete and new session is requested on ajax call to load again.

    For more details refer below link: https://oracle-concepts-learning.blogspot.com/2019/07/oracle-gtts.html