Loading java class to oracle database
692864Feb 25 2010 — edited Feb 26 2010All ,
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