Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NNL-00524: Replaces a data item with another data item

1 Answers  


ORA-25206: enqueue failed, enqueue to exception queue string.string not permitted

1 Answers  


ORA-16745: unable to add DB_UNIQUE_NAME string into The DG_CONFIG list because it is full

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


QSM-01095: no suitable grouping_id found in MV with grouping sets

1 Answers  






ORA-28528: Heterogeneous Services datatype conversion error

1 Answers  


ORA-00217: controlfile could not be resized for migration from 9.0.1

1 Answers  


ORA-07290: sksagdi: specified directory for archiving does not exist.

1 Answers  


ORA-24366: migratable user handle is set in service handle

1 Answers  


NZE-29008: Bad DH Param key length

1 Answers  


ORA-09319: slgtd: unable to obtain the current date and time

1 Answers  


ORA-31399: Cannot contact LDAP server string at port number

1 Answers  






Categories