By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,686 Members | 1,558 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,686 IT Pros & Developers. It's quick & easy.

Java Stored Procedure extraction from Oracle database.

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Thank you for the detailed information,

Suresh Tri
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.