Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: c-shell: use of << EOF and piping
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
![]() |
![]() |