sql*plus

Hi everybody,

Using
SQL*Plus: Release 3.2.3.0.0
under
[Quoted] [Quoted] 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 CEST