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
- Data Science
- Android
- AJAX
- ASP.net
- C
- C++
- C#
- Cocoa
- Cloud Computing
- HTML5
- Java
- Javascript
- JSF
- JSP
- J2ME
- Java Beans
- EJB
- JDBC
- Linux
- Mac OS X
- iPhone
- MySQL
- Office 365
- Perl
- PHP
- Python
- Ruby
- VB.net
- Hibernate
- Struts
- SAP
- Trends
- Tech Reviews
- WebServices
- XML
- Certification
- Interview
categories
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
Count number of vowels, consonants and digits in a String in Java
Student marks calculation program 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
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