Re: SQL*Plus reading from standard input?

Try:

  set pause off;

In article <3jg0l9$9al_at_hearye.mlb.semi.harris.com>, tgillesp_at_ms13.mis.semi.harris.com (Tom Gillespie) writes:
|> Does SQL*Plus read from standard input correctly on unix (Solaris)?
|> I am having a difficult time trying to run a shell script that
|> contains a "here" document (re-directing standard input to the
|> script file) with SQL*Plus commands in it.
|>
|> SQL*Plus seems to read the input stream ok until it prints the
|> "Pres return to continue" message. Then it ignores the rest of the
|> input from the script.
|>
|> All I want to do is run a script like this:
|>
|> #!/bin/ksh
|> sqlplus user/pass << !
|> select * from my_table;
|>
|> !
|>
|> Any help would greatly be appreciated !
|> --
|> Tom Gillespie - -
|> Harris Semiconductor | | | |
|> Manufacturing Systems _/\/\/\/
|> Palm Bay, FL | | | |
|> Tom.Gillespie_at_harris.com _ _
|>
Received on Tue Mar 07 1995 - 19:32:53 CET