Re: How to create temporary table in PL/SQL block

Use DBMS_SQL, you can execute any sql from it in a pl-sql, as long as you have the proper grants.

Hope it helps
NY
Meghdeep <meghdeep_at_hotmail.com> wrote in message news:8k2q8d$51c$1_at_news.chatlink.com...
>
> I need to to create a multi column temporary table in stored procedure and
> want to drop at end of it. How will I do it?
>
> I am using oracle 8.05 on windows NT.
>
> Thanks,
> Meghdeep
>
>
>
Received on Thu Jul 06 2000 - 00:00:00 CDT