sql*plus

From: ragazzone <regalia_at_tin.it>
Date: 2000/06/20
Message-ID: <8io0t9$45b$1@nslave2.tin.it>#1/1

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 Tue Jun 20 2000 - 00:00:00 CDT