batch file to run a sql script

[joe_kk]

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

thanks

[santoshym]

Hi

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

Regards

[kris109]

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]