MySQL Forums
Forum List  »  Oracle

Re: how to migrate oracle stored procedures to mysql
Posted by: Ben Krug
Date: December 12, 2007 11:36PM

Fatma - does the documentation say the toolkit will convert stored procedures? I only see where it says it will convert schemas and data.

PL/SQL syntax is non-standard and very particular to Oracle (which Oracle is proud of), so it does not transfer easily to other databases. Tom of "Ask Tom" discusses this in his Oracle books, where he talks about portability and lacks of portability.

I may be wrong, but I think the procedures will have to be gone through and re-written as MySQL stored procedures or other code. I hope someone will correct me if I'm wrong.

Options: ReplyQuote

Written By
Re: how to migrate oracle stored procedures to mysql
December 12, 2007 11:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.