"JC" <joseph.chewning_at_targacept.com> wrote in message
news:1143575430.436600.260740_at_j33g2000cwa.googlegroups.com...
> I get this error from the following line... Can anyone tell me why???
>
> colvalue number;
> mcn varchar(100);
> lotid number;
> mrn rowid;
>
> select mcn into colvalue from lotz where lot_id=lotid and rowid=mrn;
>
> I have tried this also
>
> Execute Immediate 'select '||mcn||' into '||colvalue||' from lotz where
> lot_id='||lotid||' and rowid='||mrn;
>
>
> Thanks,
>
> JC
>
you are selecting a varchar into a number. Can't do that. At minimum you
would need a to_number(mcn).
--
Terry Dykstra
Canadian Forest Oil Ltd.
Received on Tue Mar 28 2006 - 14:23:14 CST
