Java Stored Procedure extraction from Oracle database.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Suresh Tri
    #1

    Java Stored Procedure extraction from Oracle database.

    Hi all,

    I am interested in extracting the class or jar files which are stored
    as java stored procedures in Oracle. But I want to know if these are
    stored as references to external files in Oracle database or directly
    inside the database. In case if it is directly stored inside the
    database is there any way to extract it?. If I can extract these java
    files, can these be used in non Oracle applications?

    Please help,
    Thanks,
    Suresh Tri
    Tags: None
    • Hans Forbrich
      #2
      Re: Java Stored Procedure extraction from Oracle database.

      Suresh Tri wrote:
      Hi all,
      >
      I am interested in extracting the class or jar files which are stored
      as java stored procedures in Oracle. But I want to know if these are
      stored as references to external files in Oracle database or directly
      inside the database. In case if it is directly stored inside the
      database is there any way to extract it?. If I can extract these java
      files, can these be used in non Oracle applications?
      The source code for Java Stored Procedures, _when made available_, is stored
      in the dictionary. The dictionary views are discussed in detail in the
      Oracle Reference manual at http://docs.oracle.com (for Oracle9i R2 the html
      version is
      http://download-west.oracle.com/docs...a96536/toc.htm)
      and you would want to look at

      ALL_JAVA_ARGUME NTS
      ALL_JAVA_CLASSE S
      ALL_JAVA_DERIVA TIONS
      ALL_JAVA_FIELDS
      ALL_JAVA_IMPLEM ENTS
      ALL_JAVA_INNERS
      ALL_JAVA_LAYOUT S
      ALL_JAVA_METHOD S
      ALL_JAVA_NCOMPS
      ALL_JAVA_RESOLV ERS
      ALL_JAVA_THROWS
      ALL_SOURCE (contains the actual source code)

      It's much easier to see the source when using the Oracle Enterprise Manager
      console.

      All of this is discussed in the Java Developer's Guide at
      Invalid URL
      http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96656/toc.htm

      in CHapters 2 and 7.

      If you extract the java 'files' you can use them anywhere assuming you have
      all the appropriate class libraries available to the target JVM. Note that
      anything other than trivial code will likely call Oracle-supplied (or
      proprietary) classes, and those might only be available as compiled java,
      compiled to 'C', or wrapped PL/SQL.

      /Hans

        Comment

        • Suresh Tri
          #3
          Re: Java Stored Procedure extraction from Oracle database.

          Thank you for the detailed information,

          Suresh Tri

            Comment

            Previous template Next
            Working...