File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to call an Oracle Stored Procedure from CMD file? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to call an Oracle Stored Procedure from CMD file?" Watch "How to call an Oracle Stored Procedure from CMD file?" New topic
Author

How to call an Oracle Stored Procedure from CMD file?

Asha BS
Greenhorn

Joined: Aug 01, 2001
Posts: 3
Hi,
I have an Oracle Stored Procedure(SP) , I want to schedule win NT to call the SP at certain time interval. I heard I have ti write a .cmd file to do that. How can I call oracle SP from .cmd file. The SP is like a batch process, neither takes input parameter nor returns.
Asha
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
You should be able to kick off sqlplus from command line. The sqlplus file you kick off would then do the execute of the stored procedure.
HTH
Dan
Asha BS
Greenhorn

Joined: Aug 01, 2001
Posts: 3
What do you mean by kick off SQL Plus from the command line?
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
If you have the PC versions of the software...
you can type sqlplus id/pass at the command line
Dan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to call an Oracle Stored Procedure from CMD file?
 
Similar Threads
Need help in iBatis !
Call a stored Proc from JavaSript? Is it possible?
How can we call a stored procedure from java file
Stored Procedure Making Two different Server Database Call
Calling a JMS client from Oracle Trigger