javaload, JAR references : how it really works ?
504563Apr 14 2006 — edited Apr 14 2006Hello,
I'm creating Oracle functions that are mapped on static methods from a Java class. I have difficulties on creation and compilation. I need to put some JAR files in Oracle for imports of my class, but I have different issues about that (I'm using command line "loadjava -user log/pwd c:\package.jar" to load JAR files) :
- one JAR has no errors with the command line, but when I check in the dba_objects view, most of the class have the status INVALID.
- another JAR has no errors with the command line, but when I check in the dba_objects view, none of the class of the package are loaded.
- other JAR show error messages with the command line :
* ORA-29545: User has attempted to load a class into a restricted package. Permission can be granted using dbms_java.grant_permission
* ORA-29533: tentative d'écrasement de la classe ou de la ressource "class" lors de la définition ou de la compilation de "schema"."class"
Can someone explain me how to load correctly JAR files into Oracle ?
Thanks in advance,