Comment Added by : zia rockstar

Comment Added at : 2016-07-29 12:51:52

Comment on Tutorial : Calling a Stored Procedure from JDBC in Java By Watson
if my pl/sql procedure is like this:

CREATE OR REPLACE PROCEDURE CLONING
as
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'clone',
job_type => 'EXECUTABLE',
job_action => '/home/oracle/project/clone_db_auto/clone_test_automated_full.sh',
start_date => SYSDATE,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1',
enabled => TRUE,
auto_drop => FALSE,
comments => 'Calling shell script from Oracle'
);
END
/
how to call it in java and get the output.

View Tutorial