Re: loadjava problem

From: Boris Treiger <boris.treiger_at_capco.com>
Date: Thu, 9 Aug 2001 08:39:10 +0200
Message-ID: <3b722fc4$0$12229$4d4efb8e@news.be.uu.net>

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 - 01:39:10 CDT