Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> What am I doing wrong (RTRIM, PL/SQL)
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:20:18 CDT
![]() |
![]() |