How to fix the Oracle error PLS-01905: : character string buffer too small?

In this post, you’ll learn more about the Oracle ErrorPLS-01905: : character string buffer too small with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-01905: : character string buffer too small

Reason for the Error PLS-01905: : character string buffer too small

An error was encountered while moving a character string from a source to a destination. This error occurs if, for example, an attempt is made to move a a character string of 10 characters into a 1 character buffer. The cause of this error may not always be obvious. For example, the following will result in this error: a varchar2(1); b number; b := 10; a := b; An error results because an implicit conversion causes the number 10 to become the character string ’10’, which does not fit in the character buffer of 1 allocated for the variable a.

How to fix the Error PLS-01905: : character string buffer too small ?

You can fix this error in Oracle by following the below steps

First, look for character string assignment statements where the buffer size is mismatched. If there are none found, then consider the implicit conversion case illustrated in the example above.