This content has been marked as final. Show 4 replies
devvvy wrote:You don't create it inside your function.
so if I CREATE GLOBAL TEMPORARY TABLE twice on second pass of my recursive function what then...?
You create the GTT once on your database outside of the function and then just leave it there and use it.
Tables should not be dynamically created and dropped.
Only other database engines such as SQL Server use the concept of creating temporary tables during the execution of code. Oracle uses a "create once, use whenever" methodology.