No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

ORA-22923: amount of data specified in streaming LOB write is 0
Next thread: Grid Infrastructure Ora12r2
Prev thread: Hybrid model (OLAP+OLTP)for transnational database - how to do efficient design / SQLs

Message Score Author Date
Hi , I have an Oracle function that converts XM...... Santhosh Kumar Aug 06, 2019, 09:16
Hi All, Appreciate your help on this. Santho...... Santhosh Kumar Aug 06, 2019, 11:26
Hi Santhosh, As the error message states it, th...... Lauri Aug 12, 2019, 14:56
Hi Santhosh/Lauri, Im also facing the same issu...... Arun Manepalli Oct 12, 2019, 15:09

Follow up by mail Click here


Subject: ORA-22923: amount of data specified in streaming LOB write is 0
Author: Santhosh Kumar, Singapore
Date: Aug 06, 2019, 09:16, 105 days ago
Os info: windows
Oracle info: 11g
Message: Hi ,

I have an Oracle function that converts XML stored inside a NCLOB column into XML table type. I have the following error while selecting the data using that function from a view. How can I resolve it?

ORA-22923: amount of data specified in streaming LOB write is 0
ORA-06512: at "DBO.FNGETAUDITDETAILXML", line 4
22923. 00000 - "amount of data specified in streaming LOB write is 0"
*Cause: Trying to write LOB value via the streaming mechanism (i.e.
unlimited write) but the input amount of data to stream was
specified as 0. Thus, the user is trying to write 0 bytes to
the LOB value.
*Action: Write more than 0 bytes to the LOB value.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: ORA-22923: amount of data specified in streaming LOB write is 0
Author: Santhosh Kumar, Singapore
Date: Aug 06, 2019, 11:26, 105 days ago
Message: Hi All,

Appreciate your help on this.

Santhosh
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-ORA-22923: amount of data specified in streaming LOB write is 0
Author: Lauri, Netherlands
Date: Aug 12, 2019, 14:56, 99 days ago
Message: Hi Santhosh,

As the error message states it, the error is raised because an attempt is made to insert 0 bytes to a LOB.
You could check if the value to insert to the LOB is empty or not before to insert in the LOB.
Check first if the value to be inserted in the LOB is empty or not, and take the corresponding action for.
Here an idea for that check:
https://stackoverflow.com/questions/521490/how-do-i-test-if-a-column-equals-empty-clob-in-oracle

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-ORA-22923: amount of data specified in streaming LOB write is 0
Author: Arun Manepalli, United States
Date: Oct 12, 2019, 15:09, 38 days ago
Message: Hi Santhosh/Lauri,

Im also facing the same issue. Could you please help me with your inputs.

Im trying to merge columns on certain rules using function# DBMS_XMLGEN.CONVERT and facing below issue

ORA-22923: amount of data specified in streaming LOB write is 0 ORA-06512: at "SYS.DBMS_XMLGEN", line 29 ORA-06512: at "SYS.DBMS_XMLGEN", line 301 ORA-06512: at line 1

Could you please check?

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here