SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

best way to automate conversion of ms sql stored procedures

2988654Jul 9 2015 — edited Jul 10 2015

Hello,

What is the best way to automate the conversion of MS SQL stored procedures to PL/SQL?

We have tried workbench in SQL developer. But the generated code did not look very optimal.

The things that are challenging for workbench are...

1. temp tables

2. conversion of data types

3. update statements with joins

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2015

Added on Jul 9 2015

6 comments

463 views