returning a ref cursor on a Global Temporary table
705692Jul 23 2009 — edited Jul 24 2009I realize this is probably not feasible but I am manipulating data and storing it in a GTT and I wish to return that transformed data out as a ref cursor is this possible to do? I also dont want a static table because this is a heavily hit procedure and I do not want to have to keep track of which session is which data not to mention contention between them.
I am using Oracle 10g on Windows server 2008