Re: Converting SQL Server Stored Procedures to Oracle using Migration Workbench
Date: Wed, 19 May 1999 03:44:56 +0200
Message-ID: <7ht4vj$ekp$1_at_front4m.grolier.fr>
[Quoted] With DBMS_SQL (Dynamic SQL) you can create and drop tables on the fly in
stored procedures.
[Quoted] 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)
[Quoted] 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 Wed May 19 1999 - 03:44:56 CEST