Problem:
Example:
Declare
v_variable1 varchar(5);
BEGIN
select '123456' into v_variable1 from dual;
END;
/
Declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 4
Cause: Variable length into clause v_variable1 is 5 character where output that trying to store in that variable is more than 5 character which cause the error.
Solution:
Increase the length of the variable v_variable1.
Example:
Declare
v_variable1 varchar(6);
BEGIN
select '123456' into v_variable1 from dual;
END;
/
PL/SQL procedure successfully completed.