How do a call a Java jar file from Oracle PL/SQL?

java oracle11g onejar
Ground Hog picture Ground Hog · Jan 31, 2013 · Viewed 7.2k times · Source

My customer wants to be able to call a jar file from Oracle PL/SQL.

Java 1.6, Oracle 11g R2

How do I do this?

Answer

Ground Hog picture Ground Hog · Feb 3, 2013

I did a bit of research into loadjava (the program that loads classes into Oracle). Sounded like a pain in the butt.

So I opted to run my jar outside Oracle but called from Oracle DBMS_SCHEDULER by PL/SQL.

Here's how:

BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name            => 'testjar',
program_type            => 'EXECUTABLE',
program_action          => 'C:\MYSTUFF\testjar.bat',
enabled                 => TRUE,
comments                => 'test testjar'
);
END;
/

begin  
dbms_scheduler.create_job  
 (job_name => 'testjar_job',  
  program_name=> 'testjar',    
  enabled=>true,  
  auto_drop=>false,  
  comments=>'Only run immediately by dbms_scheduler.run_job');  
end; 
/


begin  
    dbms_scheduler.run_job('testjar_job',TRUE);  
end;  
/

Related questions

IO Error: The Network Adapter could not establish the connection

I am new to Oracle, and am trying to run a simple example code with Java, but am getting this error when executing the code.. I am able to start up the listener via CMD and am also able to …

Read More
java.sql.SQLException: Missing IN or OUT parameter at index:: 1

I made some Java 1.6-Oracle11g-JDBC (using OJDBC 6) code (below). I am getting an exception - java.sql.SQLException: Missing IN or OUT parameter at index:: 1 Why is this happening and how do I fix it ? My output is- create …

Read More
Oracle SqlDeveloper JDK path

I have recently installed sqldeveloper but i'm getting the below warning window when I try to launch it. This is causing the sqldeveloper to run very very slow and it hangs frequently I have tried editing the file sqldeveloper.cong …

Read More