ORA-24502: codepoint length overflows

Cause : Returned buffer has more codepoints than allowed

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Set OCI_MAXCHAR_SIZE large enough to accommodate

update : 26-04-2017
ORA-24502

ORA-24502 - codepoint length overflows
ORA-24502 - codepoint length overflows

  • ora-28655 : Alter table add overflow syntax error
  • ora-10627 : Dump the content of the index leaf block
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-01307 : no LogMiner session is currently active
  • ora-28268 : Exceeded the maximum allowed size for Context information in a session
  • ora-30690 : timeout occurred while registering a TCP/IP connection for data traffic detection
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-07745 : slemcl: $CLOSE failure
  • ora-13006 : the specified cell number is invalid
  • ora-24381 : error(s) in array DML
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-30159 : OCIFileOpen: Cannot create the file or cannot open in the requested mode
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • ora-02351 : internal error: string
  • ora-24171 : creation properties are only for internal use
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-29346 : invalid tablespace list
  • ora-02161 : invalid value for MAXLOGFILES
  • ora-01191 : file string is already offline - cannot do a normal offline
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-10656 : Table is in unusable state due to incomplete operation
  • ora-22933 : cannot change object with type or table dependents
  • ora-09217 : sfsfs: failed to resize file
  • ora-19286 : XP0017 - unable to resolve call to function - string
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-01016 : This function can be called only after a fetch
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.