Raj Venkata

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

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