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


Example:

 

declare
myname varchar2(5);
begin
myname := 'Anar Godjaev';
end;
/
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 4

Solution:

declare
myname varchar2(20);
begin
myname := 'Nimish Garg';
end;
/
 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: