Hi, We have been using Oracle Stored Procedures for a while and would like to switch to Java Stored Procedures. Is there a tool that I can use to port Oracle Stored Procedures to Java Stored Procdures? If I end up in doing the porting manually how much time it takes for the porting ( I would like to know approximately for let us say 1000 lines of code how much time). thanks in advace, Raj
Originally posted by Carl Trusiak: First of all, I have to ask ... Why? If the procedure can be done in PLSQL, then 90% of the time, that's the most efficient way to perform the function.
Carl is the reason why PL/SQL stored procedures more efficient than java stored procedures because they are loaded into memory? The CBT's I am learning Oracle from keep saying the PL/SQL procedures are the most efficient, but they do not explain why. Sorry for butting in Rajah.
Maybe not the most compelling reason, but we migrated our few PL/SQL SPs to java so that we only have a single language at every tier - java on the app server, java in the database, no need to maintain PL/SQL knowledge (which was pretty iffy to begin with)
"john_guthrie", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements. Thanks.