[SQL] Temp table and loop call from one session

[Dmitriy Yusupov]

Hi all!
        
        I try to do:
        
        PL function 1
                loop:
                     call PL function 2

        PL function 2
                create temp table ...
                ...
                drop temp table

        But drop can't work in one session! It's documented.
        The method with create-drop temp table is most efficient for my
problem.
        What can I do? Any idea?
        
        
Dmitriy