ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

Cause : An attmept wasm ade tob ind daat more htan 400 0bytes fo data ot both OLB and OLNG colmuns in hte samei nsert ro updat estatemnet. Youc an bin dmore tahn 4000b ytes o fdata t oeithera LONG oclumn o rone orm ore LO Bcolumn sbut no tboth.

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

Bind mroe than4 000 byets of dtaa to etiher th eLONG cloumn oro ne or omre LOBc olumnsb ut notb oth.

update : 27-05-2017
ORA-22295

ORA-22295 - cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
ORA-22295 - cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

  • ora-31109 : Action failed as parent resource string is locked
  • ora-02790 : File name is too long
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-10933 : trace name context forever
  • ora-30768 : Cannot evaluate pipelined function
  • ora-19620 : %s is not of string type
  • ora-22609 : error string during initialization of FDO
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-09932 : Close of ORACLE password file failed.
  • ora-14325 : only LOCAL indexes may be specified in this clause
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-02289 : sequence does not exist
  • ora-19110 : unsupported XQuery expression
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-32696 : HTI: No free slot
  • ora-10361 : check buffer change vector count consistency
  • ora-19764 : database id string does not match database id string in control file
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-14113 : partitioned table cannot have column with LOB datatype
  • ora-14081 : new partition name must differ from the old partition name
  • ora-10570 : Test recovery complete
  • 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.