Skip to Main Content

Oracle Database Discussions

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!

Calling Java class from Stored Procedure

user10431717Feb 8 2018 — edited Feb 8 2018

Hi Guys,

I am trying to call a java class (which is in .jar) from stored procedure. As per oracle documentation, i found that I can achieve this using dbms_java.load_java function. But when I execute this function, I am getting below error. Please let me know any thoughts to get this fixed.

exec SYS.dbms_java.loadjava('-v -r /opt/Genpac/pol/abc/webapp/WEB-INF/lib/gen-sharepoint.jar');

Error report:

ORA-29532: Java call terminated by uncaught Java exception: oracle.aurora.server.tools.loadjava.ToolsError:

Error during loadjava: Failures occurred during processing.

Check trace file for details

ORA-06512: at "SYS.DBMS_JAVA", line 655

ORA-06512: at line 1

29532. 00000 -  "Java call terminated by uncaught Java exception: %s"

*Cause:    A Java exception or error was signaled and could not be

           resolved by the Java code.

*Action:   Modify Java code, if this behavior is not intended

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2018
Added on Feb 8 2018
5 comments
646 views