This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

convert to java stored proceedure for oracle

 
Mike Cunningham
Ranch Hand
Posts: 130
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic