Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2006
    Posts
    9

    Unanswered: Exit on SQL .bat file?

    Hello,

    What do I have to do to automatically exit the MS-DOS screen when running a SQL process via a batch file?

    This is my .bat file:
    SQLPLUS user/pw@database @test.sql
    exit

    I thought 'exit' would do the job for me?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've moved this thread since it is actually an Oracle/Windows question, not a SQL question.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by zimon1972

    I thought 'exit' would do the job for me?
    Yes, if it appears at the end of test.sql

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Actually, it (EXIT) should be the last line in both .SQL (terminated by semicolon) and .BAT file.

  5. #5
    Join Date
    Nov 2005
    Location
    Honolulu HI
    Posts
    119
    there is a setting under the "ms-dos" windows "properties" settign that says, "close on exit" and its a check box
    make sure that is on



    (man, fat fingers syndrom tonight, had to fix speeling)
    .
    .
    http://www.HawaiianHope.org
    Providing Technology services to non profit orgs, Homeless Shelters, Food Pantries, Clean And Sober Houses and more.
    To date we have given away over 900 free computers !
    __________________________
    caeli enarrant gloriam Dei !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •