Comment on Tutorial - Calling a Stored Procedure from JDBC in Java By Watson



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



Subscribe to Tutorials

Related Tutorials

Program using concept of byte long short and int in java

Update contents of a file within a jar file

Tomcat and httpd configured in port 8080 and 80

Java File

Java String

Count number of vowels, consonants and digits in a String in Java

Reverse a number in Java

Student marks calculation program in Java

Handling Fractions in Java

Calculate gross salary in Java

Calculate average sale of the week in Java

Vector in Java - Sample Program

MultiLevel Inheritance sample in Java

Multiple Inheritance sample in Java

Java program using Method Overriding

Archived Comments

1. nativeFinalize: Error closing Handle 6
and

View Tutorial          By: yash at 2008-05-16 17:43:42

2. nice intelligent work
View Tutorial          By: santosh at 2010-11-28 01:18:50

3. Hi Friends.... This code is working correctly with
View Tutorial          By: kasi at 2009-11-25 23:52:56

4. how to connect the database in servelet use to sta
View Tutorial          By: sudhir singh tomar at 2011-04-28 03:10:34

5. how to execute all these five programms tell me st
View Tutorial          By: shweta at 2008-09-24 07:35:22

6. how can get ip url...?
View Tutorial          By: arjuna at 2011-11-23 03:31:46

7. i want to learn j2me basic to ....
View Tutorial          By: gopiraj at 2012-12-21 11:52:01

8. Nice one for jsp learners.
View Tutorial          By: Vignesh at 2011-07-14 04:04:55

9. not bad
View Tutorial          By: JUST_PREET at 2013-03-06 11:37:15

10. ...indeed its a helpful brief explanation, coz our
View Tutorial          By: elaine22 at 2010-01-22 01:27:16