aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Is this possible?" Watch "Is this possible?" New topic
Author

Is this possible?

nand rai
Greenhorn

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
Marshal

Joined: May 26, 2003
Posts: 30753
    
156

Nand,
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.


[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
Greenhorn

Joined: Dec 28, 2007
Posts: 19
Nand,

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

Thanks,
Pradeep


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is this possible?