Re: loadjava problem

Igor TN wrote:

> 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.

In which schema is it then?
You can look this up in the all_objects view.

> 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".

The resolving of PL/SQL is at runtime and not at the creation.

Uwe Received on Mon Aug 13 2001 - 10:01:48 CDT