-
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
-
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
Santosh
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|