Forums Register Login

How to call an Oracle Stored Procedure from CMD file?

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
What do you mean by kick off SQL Plus from the command line?
+Pie Number of slices to send: Send
If you have the PC versions of the software...
you can type sqlplus id/pass at the command line
Dan
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2821 times.
Similar Threads
Need help in iBatis !
Stored Procedure Making Two different Server Database Call
Calling a JMS client from Oracle Trigger
Call a stored Proc from JavaSript? Is it possible?
How can we call a stored procedure from java file
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 11:46:29.