wood burning stoves 2.0*
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
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30382
    
150

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


 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Is this possible?