From: Igor TN <itovsto@emory.edu>
Newsgroups: comp.databases.oracle.server,comp.lang.java.databases
Subject: loadjava problem
Date: Wed, 8 Aug 2001 20:40:37 -0400
Organization: Emory University
Lines: 30
Message-ID: <Pine.GSO.4.05.10108081941270.26119-100000@paladin.cc.emory.edu>
NNTP-Posting-Host: paladin.cc.emory.edu
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Trace: lendl.cc.emory.edu 997317638 15963 170.140.1.29 (9 Aug 2001 00:40:38 GMT)
X-Complaints-To: abuse@emory.edu
NNTP-Posting-Date: 9 Aug 2001 00:40:38 GMT
X-Sender: itovsto@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@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". 

Please, what am I possibly doing wrong?

Thank you very much.
Igor