Hi All!
I have a little Java code that I want to use inside my Oracle 11g server as "Java source". It has 3 external .jar dependecies, the command line version of the Java code is running, no errors. After I loaded the jar files (all three as DBA) like this (from sqlplus):
exec dbms_java.loadjava('-r -jarasresource ./external-jar-file-one.jar');
I see:
PL/SQL procedure successfully completed.
So I created the Jave source ("create or replace and compile java source named XYZ as"), but after I execute it I get "Compiled with errors"
As far as I see the loaded classes are invalid (USER_ERRORS are full of it), all of them say referenced object XY could not be resolved.
I really don't know what else should I do, I'm not that familiar with Oracle administration Can someone help me out, please?
Thank you very much!