Home » SQL & PL/SQL » SQL & PL/SQL » plsql fuction
plsql fuction [message #20856] Tue, 25 June 2002 22:37 Go to next message
Messages: 85
Registered: October 2000
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
Re: plsql fuction [message #20861 is a reply to message #20856] Wed, 26 June 2002 01:09 Go to previous message
Messages: 99
Registered: March 2002

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,

Previous Topic: Can you use an Index in the definition or use of a view ?
Next Topic: Update Statement
Goto Forum:

Current Time: Mon Oct 21 13:04:52 CDT 2019