APEX interactive report on global temporary table
760343Dec 4 2010 — edited Dec 6 2010Hi,
I was trying to build an interactive report on a global temporary table (preserve on commit) , which is created through a cronjob once per hour. Problem is that the sql to create the temporary table runs about 10 minutes, so putting the sql directly into the page does not make sense.
When I create the report, it sees all the columns, but no data. I can query the data fine from sqlplus or through sqldeveloper. Am I doing something wrong?
Thx,
Dennis