i want to create a batch file which calls a sql script. any one has the answer. pls tell me where i can get information about this
You have to use the same step for calling a sql script I have allready written the steps in the query where you had asked for a Batch file for NT to execute a procedure you can use the same steps
No big deal really: Here is a test.bat that takes user and password from the environment and runs 3 scripts
##echo 'Running script 1'
sqlplus -s USER/PASSWORD @t_up_1.sql
##echo 'Running script 2
sqlplus -s USER/PASSWORD @t_pre_1.sql
##echo 'Running script 3'
sqlplus -s USER/PASSWORD @t_post_1.sql
create the .bat file and double click on it.
[Edited by kris109 on 05-14-2001 at 12:38 PM]
Click Here to Expand Forum to Full Width