• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Paul Clapham
  • Rob Spoor
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Carey Brown

Calling java stored procedure

Ranch Hand
Posts: 385
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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

1.how do i call a method from this jar file from oracle?

2.do 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?

5.how do i call if the method is instance not static?

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic