How to call an Oracle Stored Procedure from CMD file?
Asha BS
Greenhorn
Joined: Aug 01, 2001
Posts: 3
posted
0
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
posted
0
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
posted
0
What do you mean by kick off SQL Plus from the command line?
Daniel Dunleavy
Ranch Hand
Joined: Mar 13, 2001
Posts: 276
posted
0
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: How to call an Oracle Stored Procedure from CMD file?
0
