Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: loadjava: JAR with long package names
bung_ho_at_hotmail.com (bung ho) wrote in message news:<567a1b1.0306160828.17c8e465_at_posting.google.com>...
I think OP needs to find out if jar file was loaded successfully and classes are valid.
SQL> SELECT object_name, sys.dbms_java.longname(object_name) longname, status
FROM user_objects WHERE object_type LIKE 'JAVA%' AND sys.dbms_java.longname(object_name) LIKE 'com/dataimages/%';
If status is INVALID, then reload jar file, but this time use -resolve option with loadjava as seen in your example.
Regards
/Rauf Sarwar
Received on Mon Jun 16 2003 - 17:02:02 CDT