Re: sql*plus
From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/06/21
Message-ID: <nr445.47$jf2.10771_at_wdc-read-01.qwest.net>#1/1
Date: 2000/06/21
Message-ID: <nr445.47$jf2.10771_at_wdc-read-01.qwest.net>#1/1
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 CEST