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

Thread: exit sqlplus

  1. #1
    Join Date
    Jan 2002
    Posts
    3
    (once again)
    I'm trying to run sqlplus and submit my SQL-Commands through a batch-file, e.g.: sqlplus peter/hans @/mydir/myfile.
    It works up to the point, where I try to exit sqlplus, by having a line with EXIT in my batch-file.
    How will it work?

    knoll

  2. #2
    Join Date
    Nov 2001
    Posts
    34
    you have write exit; in file .sql and write exit; in file .sh or file batch

  3. #3
    Join Date
    Jan 2002
    Posts
    3
    that's what I've tried in different ways, but it doesn't work;-)
    I somehow think, there's something else.

  4. #4
    Join Date
    Jan 2002
    Posts
    3
    I am sorry to disappoint you, but there's really nothing else.

    Write a .sql file with the following:

    select * from v$session;
    exit

    Now write a .bat with the following:
    sqlplus system/manager@instance @mysql.sql
    exit

    I promise that this will work !

    If it doesn't try following step by step in command-line...

    Hope this helps...
    Best Regards,

    Helder

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