File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Is this possible? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Is this possible?" Watch "Is this possible?" New topic

Is this possible?

nand rai

Joined: Feb 17, 2009
Posts: 27
Hi ,

I am wondering if i use oracle store procedure and put whole lot of logic in there and using callable statement get the results is the one way, but what will happen if i move from Oracle database to DB2 ? how do i covert the store procedure logic.

is there any tool that can convert pl/sql code(Stored procedure) from one database to other?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32301

You would have to rewrite the stored procedure. There isn't a tool. If you think it is likely that you will need to switch databases, you would be well served to not create new large stored procedures.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Pradeep Arun

Joined: Dec 28, 2007
Posts: 19

Migration Tool Kits are available for this conversion but they may not convert completly. There are some limitations as well.


I agree. Here's the link:
subject: Is this possible?
It's not a secret anymore!