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

LFI-00003: Internal exception code. icode = [string], [string].

1 Answers  


ORA-30688: maximum program calling depth exceeded

1 Answers  


I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 Answers  


SQL-02137: Multi-threaded agent with no RETURNING clause present

1 Answers  


DRG-11225: Third-party filter timed out.

1 Answers  


TNS-03511: Used parameter files: string

1 Answers  


LSX-00165: content type of "~S" must be simple type

1 Answers  


AMD-00154: Cannot delete session object "string" in Workspace "string"

1 Answers  


ORA-32818: AQ queue string does not exist

1 Answers  


SQL*Loader-00252: Sort data sets are not used by SQL*Loader

1 Answers  


ORA-29351: can not transport system, sysaux, or temporary tablespace 'string'

1 Answers  


TNS-01176: Error in loading the new parameter value

1 Answers  


Categories