Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to view java stored procedure?

How to view java stored procedure?

From: James Egan <jegan472_at_comcast.net>
Date: Sat, 27 Jan 2007 00:12:14 -0500
Message-ID: <sIydnfuamcOzQifYnZ2dnUVZ_hmtnZ2d@giganews.com>


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 %'

   ORDER BY object_type, object_name; Received on Fri Jan 26 2007 - 23:12:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US