shell script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: shell script

  1. #1
    Join Date
    Oct 2000
    Posts
    144
    Hi everyone,
    I create a shell script in order to logon and run the .sql script. It does logon, but
    it stays at the SQL> prompt and does not runt he script. I don't know what did
    I do wrong.

    test.sh script
    -------------
    cd $ORACLE_BASE
    sqlplus (username)/(password)
    @sample.sql


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your problem is that once sqlplus starts, it never gets to the next step in your .sh script. The .sql script must be run as part of the command line call to sqlplus.

    Try...

    cd $ORACLE_BASE
    sqlplus (username)/(password) @sample.sql
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    This solved my question too.
    Elin@trend

  4. #4
    Join Date
    Oct 2000
    Posts
    144

    :)

    cool....it works....thank you so much Jeff

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Thanks Jeff, this solved my question too!


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