Re: Stored procedures from MS SQL 7.0

The S& version of Migration Assistant should be out soon. I beta tested it
and it converted most of our Stored Procedures pretty well. But to be honest,
if they are complex at all you may want to learn pl/sql and rewrite them to
take advantage of its functionality. Cursors are handled completely different
and are a pain.

Majken Longhi wrote:

> Big problem:
>
> I have a DB with 20 stored procedures in MS SQL.
> The DB has to be moved to Oracle...
> But what about my Stored Procedures??
> Do I have to write them all over in SQL*PL or can I do something
> smarter?
> If yes.. what?
>
> Thanks Majken

--

Tony Johnson
The Straford Group
PO Box 2875
Chandler, AZ 85225

Email : tonyj_at_primenet.com
Phone : (480)497-9685 Received on Wed Nov 17 1999 - 21:54:52 CST