It's not a secret anymore!
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
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: 33130

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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!