aspose file tools
The moose likes JDBC and Relational Databases and the fly likes convert to java stored proceedure for oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "convert to java stored proceedure for oracle" Watch "convert to java stored proceedure for oracle" New topic

convert to java stored proceedure for oracle

Mike Cunningham
Ranch Hand

Joined: Nov 14, 2000
Posts: 130

I have a java servlet, 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?

Any help is much appreciated.


Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 31668

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
wood burning stoves
subject: convert to java stored proceedure for oracle