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-01027: bind variables not allowed for data definition operations

1 Answers  


ORA-16705: severe internal error in resource guard

1 Answers  


ORA-08268: create_ora_addr: cannot close nameserver

1 Answers  


ORA-01312: Specified table/column does not exist

1 Answers  


ORA-01504: database name 'string' does not match parameter db_name 'string'

1 Answers  


QSM-02023: nested cursor

1 Answers  


O2I-00122: Invalid filename for the INITFILE file

1 Answers  


ORA-30687: session terminated by debugger

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


ORA-00065: initialization of FIXED_DATE failed

1 Answers  


ORA-24433: This statement has already been prepared using OCIStmtPrepare2.

1 Answers  


IMP-00004: invalid username or password

1 Answers  


Categories