467,081 Members | 974 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

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
Jul 19 '05 #1
  • viewed: 10806
Share:
2 Replies
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_ARGUMENTS
ALL_JAVA_CLASSES
ALL_JAVA_DERIVATIONS
ALL_JAVA_FIELDS
ALL_JAVA_IMPLEMENTS
ALL_JAVA_INNERS
ALL_JAVA_LAYOUTS
ALL_JAVA_METHODS
ALL_JAVA_NCOMPS
ALL_JAVA_RESOLVERS
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
http://download-west.oracle.com/docs...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
Jul 19 '05 #2
Thank you for the detailed information,

Suresh Tri
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by digi_newbie | last post: by
7 posts views Thread by Hawkeye | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.