ORA-22923 When Updating Column Of Type XMLTYPE STORAGE BINARY (Doc ID 2261718.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to update a table with an xmltype column -

UPDATE FSGP_FUNDS_TRANSFER#NAU SET XMLRECORD = updateXML(XMLRECORD ,'//c19/text()','XXInfo','//c20/text()','XXInfo','//c27/text()','XXInfo','//c27/text()','XXInfo','//c196/text()','XXInfo','//c126/text()','XXInfo','//c67[@m="64"]/text()','aDEB.TITLEa','//c67[@m="65"]/text()','aCRED.TITLEa','//c67[@m="86"]/text()','XXInfo','//c67[@m="7"]/text()','XXInfo','//c67[@m="108"]/text()','XXInfo','//c67[@m="110"]/text()','XXInfo') WHERE ROWID BETWEEN :start_id AND :end_id

the following error occurs.

ERROR
-----------------------
ORA-22923: amount of data specified in streaming LOB write is 0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms