Re: Help !!!ORA-06502: PL/SQL: numeric or value error: character to number conversion error

JC wrote:
> 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

I agree with what Terry said but I am a bit concerned about your use of ROWID and the values. It looks like a bad idea even if properly implemented.

How is this being used and why?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)