*
The moose likes Oracle/OAS and the fly likes Can we convert the PL/SQL code to be used in Mysql? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Can we convert the PL/SQL code to be used in Mysql?" Watch "Can we convert the PL/SQL code to be used in Mysql?" New topic
Author

Can we convert the PL/SQL code to be used in Mysql?

Vijaya Ragavan
Greenhorn

Joined: Dec 02, 2013
Posts: 25
Is there any way to use Pl/Sql code in Mysql database operations? Any conversions to be done?
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

I'm not aware of any automated tools for the conversion. You might try to search for some using Google, but there will be several caveats along the way. The problem isn't only that the syntax is different. Some PL/SQL construct might not be possible in MySQL at all (eg. analytic functions in SQL statements, if they were used). Something might simply be done differently in Oracle than in MySQL (Oracle, for example, has global temporary tables, while MySQL would create a temporary table on the fly). But the worst is that some things might be easily ported, would be working at the first sight, but might be severely broken after the conversion: Oracle uses multiversioning concurrency control, while MySQL uses locking. Procedures that are valid for multiuser environments in Oracle might not work in MySQL (they might produce deadlocks, or -even worse- plain wrong results).

In short, the conversion will be anything but easy. You'll probably need someone who is very well versed in MySQL and at least comfortable with PL/SQL, to make sure he'll get the transition right.
Vijaya Ragavan
Greenhorn

Joined: Dec 02, 2013
Posts: 25
ya sure Thank you so much pal...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can we convert the PL/SQL code to be used in Mysql?