Click here to Skip to main content
14,332,394 members
Rate this:
Please Sign up or sign in to vote.
See more:

While Debugging the procedure i am getting
"ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The above error is occurring in the Exception part while concatenating the errors into the variable i am getting the buffer too small error.

After assigning a proper datatype with huge size i am getting the above error.

I am using VARCHAR2 as a datatype for that variable.

Can anybody having a solution for my problem.

Updated 17-Jul-12 20:25pm
krumia 18-Jul-12 2:24am
Please post your code. Can't tell anything from this description.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Based on the discussion below, it looks like the variable datatype is not enough to hold the data being passed to it.
Within PL/SQL a varchar2 can be as long as 32767;

You need to increase the data allocating more space. Discussions below has few answers suggesting ways to do it, see if they help:
ORA-06502 character string buffer too small...1[^]
ORA-06502 character string buffer too small...2[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100