Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to call an Oracle Stored Procedure from CMD file?  RSS feed

 
Asha BS
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What do you mean by kick off SQL Plus from the command line?
 
Daniel Dunleavy
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you have the PC versions of the software...
you can type sqlplus id/pass at the command line
Dan
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!