PL/SQL: numeric or value error – ORA-06502

You tried to assign a value to a varchar variable, but the value is larger than the variable can handle.

You are going to select

TO_CHAR(t_old.var_v_2) AS two - number(8)


var_v_2 - varchar2(4 char), 

You can’t select 8 characters into a variable, size of 4 characters.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top