Issue in using Global Temporary table in OAF
Hi,
I'm unable to fetch any data while using global temporary table in my custome page.
I have a requirement where i'm extending the Standard controller, on Click of submit button it navigates me to a custom page where i'm calling the PL/SQL package to insert the data into temporary tables.
But when i'm fetching the data from view object of the GTT tables to display the results in table region its not showing any data for that session. No data is getting inserted into GTT tables.
Any pointer on this how to achieve this scenario or can we use GTT tables in OAF for this requirement or not?