Answers for "numeric or value error: character string buffer too small"

1

numeric or value error: character string buffer too small

#error is due to the fact that you declare a string to be of a fixed length (say 20), and at some point in your code you assign it a value whose length exceeds what you declared.

#for example:

myString VARCHAR2(20);
myString :='abcdefghijklmnopqrstuvwxyz'; --length 26

#will fire such an error
Posted by: Guest on August-13-2021

Code answers related to "numeric or value error: character string buffer too small"

Browse Popular Code Answers by Language