File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is this possible?

 
nand rai
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 33680
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Pradeep Arun
Greenhorn
Posts: 19
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nand,

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

Thanks,
Pradeep


 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic