SQL Developer

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!

DB2 ( Procedures , Functions and Triggers ) migration To Oracle PL-SQL using SQL Developer

user4161666Mar 26 2018 — edited Mar 26 2018

Hi Oracle Techies

We are trying to evaluate SQL Developer for DB2 to Oracle. Source database DB2 has several Procedures, Functions and Triggers.

As DBAs are not granting DBA privileges , we opted to go for generation of scripts for target database Oracle 12 -C.

I ran through target database steps in one go but PL-SQL code was not translated in Oracle syntax.

Please let me know how to resolve this issue.

Thanks and Regards

Sayeef

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2018

Added on Mar 26 2018

#sql-developer

2 comments

562 views