Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading java class to oracle database

692864Feb 25 2010 — edited Feb 26 2010
All ,

I have loaded a java class into the oracle database as follows...

loadjava -u scott /tigger@ORCL "C:\com\abc\util\CallRefresh_8.java"


where CallRefresh_9.java is a .java file

then created a java stored procedure as follows


CREATE OR REPLACE PROCEDURE getURL( URL IN VARCHAR2)
AS
LANGUAGE JAVA NAME 'com.abc.util.CallRefresh.callRefresh(java.lang.String)';
/


Now my question is....

java developers say that oracle vm has all the available predefined classes to be able to execute this.....
Now they have created new classes (user defined) which is invoked by the main class above... and these new usesrdefined classes are not in VM ..
Hence they want to put those classes in .jar file and put that .jar file on the oracle server....
then invoke the main class above with classpath pointing to the jar location ... so that any references to the user defined classes are resolved...

i hope iam clear in my question please let me know if it makes sense or any thing that i can do here ...

regards
LM
d
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2010
Added on Feb 25 2010
2 comments
979 views