Pinning Java Classes

I am trying to pin a JAVA CLASS under Oracle 8.1.5 using the dbms_shared_pool.keep procedure. I have no problem pinning a normal PL/SQL procedure with:

% exec dbms_shared_pool.keep('MYUSER.MYPROCEDURE')

but when I attempt

% exec dbms_shared_pool.keep('MYUSER.MyJavaClass', 'JC');
OR
% exec dbms_shared_pool.keep('MYUSER.MyJavaClass', 'JC');
OR
% exec dbms_shared_pool.keep('MyJavaClass', 'JC');
OR
% exec dbms_shared_pool.keep('MyJavaClass.class', 'JC');

Where the class appears in the DBA_OBJECTS table with owner="MYUSER" and object_name="MyJavaClass".

I get the following error:

ERROR at line 1:

ORA-06564: object MYUSER.MyJavaClass does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 43
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 51
ORA-06512: at line 1

I cannot find anything about pinning classes in the Oracle documentation, but I did find the following in the $ORACLE_HOME/rdbms/admin/dbmspool.sql:

-- Input arguments:
--   name
--     The name of the object to keep.  There are two kinds of objects:
--     PL/SQL objects, triggers, sequences, types and Java objects,
--     which are specified by name
...
--        Value        Kind of Object to keep
--        -----        ----------------------
--          P          package/procedure/function
--          Q          sequence
--          R          trigger
--          T          type
--          JS         java source
--          JC         java class
--          JR         java resource
--          C          cursor

Any insight?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 12:10:00 CST