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

RMAN-06092: error while looking up backup piece

1 Answers  


ORA-16645: unexpected new instance interrupted current operation

1 Answers  


ORA-27483: "string.string" has an invalid END_DATE

1 Answers  


PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 Answers  


ORA-02172: The PUBLIC keyword is not appropriate for a disable thread

1 Answers  


LSX-00220: "~1S" is wrong length, should be ~2d

1 Answers  


ORA-02819: Write failed

1 Answers  


ORA-01118: cannot add any more database files: limit of string exceeded

1 Answers  


ORA-01607: cannot add logfile to the specified instance

1 Answers  


ORA-28558: HS_FDS_CONNECT_STRING undefined for non-Oracle system

1 Answers  


ORA-22160: element at index [string] does not exist

1 Answers   ICICI,


ORA-13765: Value "string" is illegal for a result limit.

1 Answers  


Categories