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 _ _