DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: batch file to run a sql script

  1. #1
    Join Date
    Apr 2001
    Posts
    21

    Exclamation

    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

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    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

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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
  •  


Click Here to Expand Forum to Full Width