ORA-06502 PL/SQL: numeric or value error: character to number conversion error;

Question

In function I have got ORA-06502 error on this line:

newlist := LTRIM(RTRIM(newlist)) + ',';

CREATE OR REPLACE FUNCTION String_To_Int_Table
(
         list VARCHAR2
       , delimiter NCHAR DEFAULT ',' 
)
RETURN t_nested_table
AS

   value VARCHAR(11);
   position INT;
   newlist varchar2(4096);
   tableList t_nested_table;
...
newlist := list;
newlist := LTRIM(RTRIM(newlist)) + ',';

I don't see any conversion problem here. /totally confused/

collapsar · Accepted Answer · 2014-05-08 15:07:14Z

3

the string concatenation operator in oracle is ||, not +.

The bytecode compiler tries to auto-convert the varchar2 operands of the sum to numbers and predictably fails.

edited May 8, 2014 at 15:07

answered May 8, 2014 at 14:58

collapsar

17.4k5 gold badges40 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ORA-06502 PL/SQL: numeric or value error: character to number conversion error;

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related