Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to view java stored procedure?
I can view which java objects are loaded as stored procedures
into the database using the sql statement below. Can anyone
tell me how to view the actual code in the database? Does it
have to do with using loadjava to load a .java file instead of
a compiled class?
-Thanks
COLUMN object_name FORMAT A30
SELECT object_name, object_type, status, timestamp
FROM user_objects
WHERE (object_name NOT LIKE 'SYS_%'
AND object_name NOT LIKE 'CREATE$%' AND object_name NOT LIKE 'JAVA$%' AND object_name NOT LIKE 'LOADLOB%') AND object_type LIKE 'JAVA %'