This content has been marked as final. Show 2 replies
I think you should not load the jar as java resource.
And I think there is no need to tell to the java source that it have to use the JAR. It will automatically look for the library.
You should load the jar file using the loadjava utility.
If it can helps, here is how I proceed :
/* LOAD .JAR FILE */ loadjava -user your_user/password@host -resolve -verbose -nodefiner C:\jdevstudio1013\jdev\lib\your_lib.jar /* LOAD PROGRAM */ loadjava -user your_user/password@host -resolve -verbose -nodefiner C:\jdevstudio1013\jdev\mywork\your_program.java /* CREATE THE PL/SQL FUNCTION */ create or replace procedure your_function(arg1 in varchar2, arg2 in varchar2) authid current_user as language java name 'your_program.your_function(java.lang.String, java.lang.String)'; /* EXECUTE */ select your_function('hello','world') from dual;
Thanks for your reply.
However, I know about this loadjava utility and I want to avoid it because this method load each class of my jar!!
If Oracle give the possiblity to create a java resource, normally we could use it instead of loading each class of the JAR file.
Do you know another way to how use the resource?