Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

convert to java stored proceedure for oracle  RSS feed

 
Mike Cunningham
Ranch Hand
Posts: 130
  • 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
Sheriff
Posts: 36406
454
Eclipse IDE Java VI Editor
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!