yes, use DBMS_SQL -- and multiple ones if you want to -- but you'll need
to query first to make sure they don't already exist -- serialize a
number onto the end of the table name to keep them straight.
DBMS_SQL doesn't like to drop tables or change them because it may try
this before the table has actually been finished with. Use a day end
procedure to drop the temp tables if space is not a problem, otherwise,
you could use UTL_FILE or something else and call dynamically built
sql*plus scripts to drop the tables once the procedure has finished with
them. Or, if the whole thing is being called from a shell, it would be
pretty easy because you could determine the names of the tables in
advance and dynamically build the scripts.
Philip Fu wrote:
>
> Dear all,
>
> Is it possible to create a temporary table within
> the scope of a stroed procedure? If so, how?
>
> Thanks.
>
> Philip
Received on Fri Nov 19 1999 - 22:34:10 CST
