Re: ORA-29531 when calling Java stored proc

cz3m36_at_my-deja.com wrote:
>
> I am attempting to use a Java stored procedure in my 8.1.5 database. I
> have used the loadjava utility to load and compile the Java source and
> published the Java method I wish to call. These steps were completed
> successfully.
>
> When I call the published stored procedure, I am receiving the
> following error message:
>
> ORA-29531: no method getAddressData in class
> com/eds/cnh/beans/map/ReverseGeoCode
>
> The method getAddressData is contained in the .java file which I
> loaded, and is defined as static.

You'd probably have to post a small code example to get any useful feedback about what could be wrong.

> I have spoken with Oracle about this problem, and they have advised me
> that every method which is called when the top level method is executed
> should be a static method.

Not true.

> I have a couple of questions:
> 1. I only need to publish/expose the method I will be calling from
> Oracle, correct?

True. You only need a call spec for the method that you intend to call. Once the call spec maps into the Java method, you're in the world of Java and can do anything you would normally do in a Java program (with various restrictions including security settings and lack of GUI classes).  

> 2. Only the published/exposed method needs to be defined as static,
> correct?

True. As I said above, once you're in the mapped method, you're in the world of Java and can create objects and call non-static methods as usual.

---Tom Received on Tue May 23 2000 - 00:00:00 CDT