Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: c-shell: use of << EOF and piping

Re: c-shell: use of << EOF and piping

From: EDS Systems Integration <shared_at_edssi.globalnet.co.uk>
Date: 1998/04/28
Message-ID: <6i4mqa$9rm$1@heliodor.xara.net>#1/1

Ben,

I suggest you put the pipeline before the data read into the first command in the pipe:

sqlplus << EOF | awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log username/password
@select_script.sql $1 $VARIABLE
EOF Regards,
Clyde Ingram, EDS UK
clydei_at_edssi.globalnet.co.uk

Ben Moretti wrote in message ...
>Howdy,
>

 .....
>and the obvious solution of
>
>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?
>
Received on Tue Apr 28 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US