This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Moving From Oracle Stored Procedure to Java Stored Procedure

 
Raj Venkata
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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. Writing a Java Stored Procedure is fairly straight forward. There are plenty of examples included those included in the examples for "Expert One on One Oracle" http://www.wrox.com/Books/Book_down.asp?sub_section=1&isbn=1861004826&subject=Oracle&subject_id=48
 
Richard Boren
Ranch Hand
Posts: 233
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
john_guthrie
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
Vishakha Ahuja
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Where can I find info on Java Stored Procedures ?
 
Raj Venkata
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Carl Trusiak
Right now we are using only oracle as the back end and now for our application we may need to support multiple databases. So we would like to use Java Stored Procedures.
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. Writing a Java Stored Procedure is fairly straight forward. There are plenty of examples included those included in the examples for "Expert One on One Oracle" http://www.wrox.com/Books/Book_down.asp?sub_section=1&isbn=1861004826&subjec t=Oracle&subject_id=48

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic