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. Hi Andi, Stig and Derick!

Nice tur

View Tutorial          By: Lasse Christiansen at 2010-05-01 01:58:14

2. good. very nice.
View Tutorial          By: anuprassana at 2007-03-03 04:22:42

3. nice
View Tutorial          By: udhay at 2011-04-01 02:48:25

4. It was really good.helped me a lot to get started.
View Tutorial          By: rohit at 2010-08-21 04:57:32

5. Thanks a ton!!! It was really very useful :)
View Tutorial          By: Ankit at 2015-05-11 12:30:41

6. hello, please i need a help.. i'm trying to make a
View Tutorial          By: Ludmila at 2012-12-10 17:56:00

7. Thanks
Your solution helped me a lot :)

View Tutorial          By: sendhil at 2010-05-28 01:12:41

8. I know core java jsp and sql. I want to retrieve d
View Tutorial          By: Vinoth at 2011-08-16 07:22:15

9. Really a appriciatable one. Can u plz send the cod
View Tutorial          By: Jeevan at 2009-04-11 12:39:45

10. Good example.

Leslie V
www.g

View Tutorial          By: Leslie V at 2009-10-14 00:47:06