This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is this possible?

 
nand rai
Greenhorn
Posts: 27
  • 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: 34839
369
Eclipse IDE Java VI Editor
  • 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
  • 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


 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic