Re: sql*plus

add SET PAGES 0

"ragazzone" <regalia_at_tin.it> wrote in message news:8io0t9$45b$1_at_nslave2.tin.it...
> Hi everybody,
>
> Using
> SQL*Plus: Release 3.2.3.0.0
> under
> NCR MP-RAS SVR4 UNIX System UNIX System V Release 4.0.
>
> In a shell wrote something like:
>
> MYCODE=`sqlplus -s $ORACLE_ID/$ORACLE_ID <<EOF
> set echo off head off feed off lines 132
> select ret_unit_ext from retail_units where lvl=0 and lvl_type ='2';
> quit;
> EOF
> `
> echo "MSGINF: MYCODE = $MYCODE".
>
>
> But when I run it I get
>
> MSGINF: MYCODE =
> 7347
>
> With the actual value of MYCODE on a second line, as if it Has a carriage
> return in head.
>
> Any suggestione to solve this.
>
> Thanks
>
>
Received on Wed Jun 21 2000 - 00:00:00 CDT