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

ORA-00342: archived log does not have expected resetlogs SCN string

1 Answers  


ORA-16584: illegal operation on a standby site

1 Answers  


ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string

1 Answers  


ORA-22887: type of REF column is not the same as that of its scoped table

1 Answers  


PLS-00571: method access through data base link not yet supported on client side

1 Answers  






RMAN-06549: connected to auxiliary database: string (not mounted)

1 Answers  


ORA-25191: cannot reference overflow table of an index-organized table

1 Answers  


ORA-12545: Connect failed because target host or object does not exist

1 Answers  


NNO-00065: loading cached data from checkpoint file "string"

1 Answers  


PLS-01906: : raw variable length too long

1 Answers  


PLS-00105: at most one forward declaration of type 'string' is permitted

1 Answers  


ORA-01192: must have at least one enabled thread

1 Answers  


Categories