Re: loadjava problem

Boris, thank you for your response,

this is how I create procedure and then call it (I have a method with a signature 'public static void greet()' in the class DBGreet) :

 CREATE OR REPLACE PROCEDURE qw_greet
 AS LANGUAGE JAVA
 NAME 'DBGreet.greet()';
 /

Procedure created.

CALL qw_greet();

ERROR at line 1:
ORA-29540: class DBGreet does not exist

Igor.

On Thu, 9 Aug 2001, Boris Treiger wrote:

> Igor,
>
> "Igor TN" <itovsto_at_emory.edu> wrote in message
> news:Pine.GSO.4.05.10108081941270.26119-100000_at_paladin.cc.emory.edu...
> > I'm trying to load a java class into the Oracle database and then to use
> > its methods as java stored procedures (Win2000, Oracle 8i server):
> >
> > loadjava -u scott/tiger_at_localhost:1521:oradb -t -r -v DBGreet.class
> >
> > Class loads and I get the following message:
> >
> > initialization complete
> > loading : DBGreet
> > creating : DBGreet
> > resolver :
> > resolving: DBGreet
> >
> > Then I connect to the database through the SQL*Plus as a user SCOTT and
> > try to check the status of the loaded class. I see the class only if I use
> > the query "SELECT * FROM ALL_OBJECTS WHERE ..." but not the query "SELECT
> > * FROM USER_OBJECTS WHERE ..." .This is already strange because the class
> > was supposed to be loaded into the schema of SCOTT.
> >
> > Then I publish the class into the SQL layer (CREATE OR REPLACE PROCEDURE
> > ...) and it works fine. But when I try to call my procedure from SQL*Plus,
> > I get the response "class DBGreet does not exist".
>
> How precisely do you call the procedure from SQL*Plus?
>
> Kind regards,
>
> Boris
>
>
> >
> > Please, what am I possibly doing wrong?
> >
> > Thank you very much.
> > Igor
> >
> >
> >
>
>
>
>
Received on Thu Aug 09 2001 - 22:22:46 CDT