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:

java stored proc

Posted by sayed on May 25, 2001 at 9:44 PM

> 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