Posts Tagged ‘Oracle Developer’

ORA-06502 : PL/SQL: numeric or valur error: Character string buffer too small

May 1st, 2016, posted in Oracle Queries
Share
ORA-06502 ,Ora Error,Oracle Error,numeric or value error,Oracle numeric or value error,Oracle DBA,Oracle Developer,Oracle Solution,Solution for ORA-06502,Character string buffer too small,Oracle numeric,Oracle value error,ORA-06502 : PL/SQL
Problem

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 23

 

Cause

a varchar2(2000);


Action

FIXED by changing how I declared the variable “a” to:

a varchar2(9000);


Note

Change the declared variable according to your requirements.

 


 

Share