Using Java in Oracle Database 11g

Question

I have Java Files (that use external libraries) that I am trying to run in Oracle SQL Developer 11g Enterprise Edition 11.2.0.3.0 .

I compiled and uploaded my code (using JDK 1.5x, I know it does not support anything higher) to the Database Java folder using these lines below from command prompt.

loadjava -user username/password@MyInstance -force -verbose -resolve -fileout Javawriter.log  -genmissing MyLibrary.jar

loadjava -user username/password@MyInstance -force -verbose -resolve -fileout Javawriter.log -genmissing MyJavaFile.java

I am wondering how can I use this Java file using SQL procedure or the Worksheet. How can I call methods in my Java Classes and return some value?

P.S. Something like this does not return me any value

Varchar(20) summaryCall = MyJavaClass.MyMethod(5,3);

What am I doing wrong? :S

@Justin Cave is absolutely correct. I also found an article for people interested docs.oracle.com/cd/B28359_01/java.111/b31225/… — awesomeniket
– awesomeniket, Commented May 20, 2014 at 19:51

Nguyen Thanh Hung · Accepted Answer · 2015-03-14 03:59:48Z

1

I have created a tutorial related to your question. You can see that here

Hope this helps :)

answered Mar 14, 2015 at 3:59

Nguyen Thanh Hung

2744 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Justin Cave · Accepted Answer · 2014-05-20 18:23:11Z

0

You'll need to create a PL/SQL wrapper function. Something like

CREATE OR REPLACE FUNCTION myMethod( p_arg1 IN NUMBER,
                                     p_arg2 IN NUMBER ) 
  RETURN VARCHAR2 
AS
  LANGUAGE JAVA NAME 
    'MyJavaClass.MyMethod (java.lang.Integer, java.lang.Integer) 
          return java.lang.String';

You'd then call the PL/SQL function

summaryCall varchar2(20) := myMethod( 5, 3 );

answered May 20, 2014 at 18:23

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

3 Comments

awesomeniket Over a year ago

Thank you Justin :) Umm .. Do these methods need to static?

Justin Cave Over a year ago

@awesomeniket - Yes, the methods that you expose in PL/SQL need to be static. That often involves writing your own Java class(es) to interact with whatever libraries you're loading in order to implement the actual business logic you need.

awesomeniket Over a year ago

Hey Justin, could you have a look at this link too? stackoverflow.com/questions/24001145/… Thanks!

Collectives™ on Stack Overflow

Using Java in Oracle Database 11g

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related