Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-13838: invalid ADDRESS value

1 Answers  


DRG-10314: logging has not been started

1 Answers  


ORA-13193: failed to allocate space for geometry

1 Answers  


EXP-00028: failed to open string for write

1 Answers  


DRG-11613: URL store: connection refused to host specified by string

1 Answers  


TNS-12204: TNS:received data refused from an application

1 Answers  


ORA-24394: invalid mode for destroying connection pool

1 Answers  


ORA-32302: object materialized views must be object ID based

1 Answers  


ORA-28577: argument string of external procedure string has unsupported datatype string

1 Answers  


NZE-29043: Read is required.

1 Answers  


ORA-38609: FI Not enough memory for tree counting, requires at least stringKB

1 Answers  


Categories