Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: c-shell: use of << EOF and piping
In comp.unix.shell Ben Moretti <crung_at_cobweb.com.au> wrote:
: sqlplus << EOF
: username/password
: @select_script.sql $1 $VARIABLE
: EOF | awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log
: does not work. i suppose i could write it to a temp file or something and
: then cat that for awk, but that's not the point is it?
sqlplus << EOF | awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log
username/password
@select_script.sql $1 $VARIABLE
EOF
should work
or
(
sqlplus << EOF
username/password
@select_script.sql $1 $VARIABLE
EOF
)| awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log
-- PGP and other useless info at \ Quan on est mort c'est tous http://www.cps.unizar.es/~spd/ \ les jours dimanche finger://daphne.cps.unizar.es/spd \ Jean Dolent VISA: 566<Can't write .signature: Disc quota exceeded>Received on Sat Apr 25 1998 - 00:00:00 CDT
![]() |
![]() |