plsql fuction [message #20856] |
Tue, 25 June 2002 22:37 |
santosh
Messages: 85 Registered: October 2000
|
Member |
|
|
hello friends ,
I got a problem that i have one procedure created in oracle server and i want to execute it from a batch file at some time automatically.Is there any way to execute the oracle function or procedure from dos command prompt which can be then included in batch file?
In linux we got isql "exec <procedure_name>" utility which i can embed in shell script but now i have to do it from dos prompt (windows environment)instead of shell. If anybody knows the answer plz reply me to my mail address or here in this forum
Thanx
Santosh
|
|
|
Re: plsql fuction [message #20861 is a reply to message #20856] |
Wed, 26 June 2002 01:09 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
in the .bat file call the sqlplus.exe programm, connect to the database and run the procedure... :
"d:OracleOra81binsqlplus.exe username/password@DBname @e:pathprocedure.sql"
Have fun,
Epe
|
|
|