No question at this time
DBA Top 10
1 A. Kavsek 8400
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. PĂ©ran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48407
Total active users1518
Act. users last 24h4
Act. users last hour1
Registered user hits last week254
Registered user hits last month927
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

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, 13 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, 13 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, 7 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