With DBMS_SQL (Dynamic SQL) you can create and drop tables on the fly in
stored procedures.
I use it to create tablespaces, users, tables, indexes ... all DDLs !
(DBMS_SQL.OPEN_CURSOR, DBMS_SQL.PARSE and DBMS_SQL.CLOSE_CURSOR).
I'm not sure it's a good way to replace temporary tables (I use permanent
tables with a SessionD column)
but perhaps it can be a useful to translate SQL Server stored procedures ?
>1. There are no temp tables in Oracle like you have in SQL Server.
>Furthermore, you can't create & drop tables on the fly in your stored
>procedures either, so you'll have to change any logic which uses temp
>tables to logic which uses a permanent table with a "SessionId"
>column that separates the data used by other connections.
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 18 1999 - 20:44:56 CDT
