I have a javaservlet, another java class & a jar file that needs to be accessible in a oracle application that is written using PL/SQL. Basically the servlet is going to be the only access point from the oracle application. Do I need to convert the servlet to a java stored proceedure? Is there any books or internet references that could help me accomplish the task?
Mike, Look into External Routines. I know you can call a compiled routine on the same box. I'm not sure if this can be extended to a servlet, but you could always write a small program to call the servlet.
Another thing to consider is pulling out everything into a separate that the servlet and stored proc can call.