File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Calling java stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Calling java stored procedure" Watch "Calling java stored procedure" New topic

Calling java stored procedure

Siva Masilamani
Ranch Hand

Joined: Sep 19, 2008
Posts: 385

Could somebody please explain me how to call a java method from oracle step by step?

I have java instance method in an application which returns Sting array.This application requires some other dependant application jar files.

I have written an Ant script which creates all the required jar files including this application and place them in the classpath of the server where oracle resides.

Now my questions are do i call a method from this jar file from oracle? i need to use Loadjava tool to load all the required jar files?Please let me know other options so that any changes in java application in future will not require to use this tool again and again.

3.when calling this java method i need to pass a system property usually in java we use the option -Dproperty_name=value.but how do i do this when calling from oracle?

4.This method returns String array and what is the correct data type for this in oracle 8? do i call if the method is instance not static?


Failure is not an option.
I agree. Here's the link:
subject: Calling java stored procedure
jQuery in Action, 3rd edition