This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Help in java Stored Procedure

Posted by Vinod Bhardwaj on March 16, 2001 at 7:21 AM

Hello
I have written a small java pgm .After compilation ,i have loaded it's class in oracle database as follow

create or replace function HELLOWORLD return VARCHAR2 as
language java name 'Hello.world() return java.lang.String';

It was without any error.
Now at sql prompt i am trying to access this procedure as

select HELLOWORLD() from dual;

I am getting error as ' Hello class can not found'
Can anybody tell me where should i keep my class file .I am working on Sun Solaris5.6 OS.

Thanks in Advance
Vinod

• java stored proc sayed May 25, 2001 at 9:44 PM (0)