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-13027: unable to read dimension definition from string

1 Answers  


ORA-26029: index string.string partition string initially in unusable state

0 Answers  


ORA-22908: reference to NULL table value

1 Answers  


AMD-00101: cannot create string "string"; metadata entity already exists

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  


RMAN-06225: shuting down automatic instance string

1 Answers  


ORA-08437: invalid picture type in picture mask

1 Answers  


ORA-36998: (XSRELGID15) LEVEL ORDER VALUESET workspace object and LEVEL RELATION workspace object have the different level dimensions.

1 Answers  


PCB-00101: Could not find or open system configuration file

1 Answers  


NNO-00055: invalid domain minimum TTL "string"

1 Answers  


ORA-27125: unable to create shared memory segment

1 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


Categories