This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes convert to java stored proceedure for oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "convert to java stored proceedure for oracle" Watch "convert to java stored proceedure for oracle" New topic
Author

convert to java stored proceedure for oracle

Mike Cunningham
Ranch Hand

Joined: Nov 14, 2000
Posts: 128
Hello,

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.

Thanks,

Mike
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26192
    
  66

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.


[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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: convert to java stored proceedure for oracle
 
Similar Threads
Java Stored Procedure in SQL Server
Oracle 10g in Sun Solaris
Database output results to Excel
JSP deployed to OAS urgent
Java Api for converting Word document to PDF?