Re: What am I doing wrong (RTRIM, PL/SQL)

You're trying to stuff 19 characters into a 10 character space. Change your declaration of col1 to varchar2(19) or more.

Bret wrote:

> Oracle 8.0.5
> I cannot find an example for what I am trying to do - I want to parse a
> string using rtrim but am having trouble.
> Here is a sample of what I am trying to do:
>
> declare col1 varchar2(10);
> begin
> col1:=rtrim('1111,2222,3333,4444',',');
> DBMS_OUTPUT.PUT_LINE(col1);
> end;
>
> These are the messages I get:
>
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at line 3
>
> What am I doing wrong? - I've tried declaring col1 as a char(10), also
> I've tried selecting into it, but nothing seems to work.
Received on Tue Sep 28 1999 - 11:50:34 CDT