PLS-01905: : character string buffer too small



PLS-01905: : character string buffer too small..

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DGM-16900: Unable to initialize client

1 Answers  


SQL*Loader-00486: sql-strings may not be specified for collection field string

1 Answers  


ORA-01945: DEFAULT ROLE[S] already specified

1 Answers  


ORA-25012: PARENT and NEW values cannot be identical

1 Answers  


KUP-04004: error while reading file string

1 Answers  


ORA-32623: incorrect use of MODEL PRESENT* functions

1 Answers  


ORA-19011: Character string buffer too small

1 Answers  


ORA-22958: This operation is not allowed in check constraints or triggers

1 Answers  


RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

1 Answers  


QSM-00788: the table string is invalid for directive string

1 Answers  


SQL-02148: ANSI Dynamic count value out of range

1 Answers  


ORA-38495: data type for the stored attribute string is inconsistent.

1 Answers  


Categories