numeric or value error: character string buffer too small
417408Aug 30 2005 — edited Aug 30 2005Hi Everyone,
I have a simple stored proc that has a cursor and some varchar/number variables that store values fetched by the cursor. I have made sure that the size of the variables is significantly larger than the corresponding columns that the cursor fetches. However, I still get the infamous "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error.
What I have done so far:
- Visually double/triple verified the columns of the cursor and compared it to the variable sizes.
- Gotten the max(length(column)) for each column returned by the cursor and verified that the size of the variables is big enough.
Question:
-Does the "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error arise in any other situations?
I am baffled by this. Any help would be really appreciated. Thanks.
-Raj