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


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
 
GeeCON Prague 2014
 
subject: How to call an Oracle Stored Procedure from CMD file?