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

ORA-19690: backup piece release string incompatible with Oracle release string

1 Answers  


ORA-38403: attribute set name may not be longer than 22 characters

1 Answers  


DRG-13011: language column must be specified when using the multi lexer

1 Answers  


LPX-00222: error received from SAX callback function

1 Answers  


ORA-31627: API call succeeded but more information is available

1 Answers  


ORA-09841: soacon: Name translation failure.

1 Answers  


AMD-00152: Workspace "string" is not currently open.

1 Answers  


ORA-12444: policy already applied to table

1 Answers  


ORA-28278: No domain policy registered for password based GLOBAL users.

1 Answers  


ORA-27125: unable to create shared memory segment

1 Answers  


ORA-07215: slsget: getrusage error.

1 Answers  


KUP-03010: OCI error getting database column type.

1 Answers  


Categories