«
»

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

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
Comments
 comments
						
Tags: , , , , , , , , , , , , 
						

							
								This entry was posted
																on Sunday, May 1st, 2016 at 12:01 am								and is filed under Oracle Queries.
								You can follow any responses to this entry through the RSS 2.0 feed.
		
																	You can leave a response, or trackback from your own site.
		
										
							
						

		
					

				

			



			

	 






Leave a Reply