Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleXMLSave how to insert empty string

497467Mar 10 2006 — edited Mar 16 2006
We try to insert the xml document below. OracleXMLSave tries to insert a null value for DESCR (which actually fails because this is a not null column). Why? Expectation is that an empty string is inserted.

Here the xml data

<ROWSET>
<ROW>...</ROW>
<ROW>
<MEQ_IID>157</MEQ_IID>
<INAME>Time</INAME>
<DESCR/>
<AODT>7</AODT>
<DTS_IID>66</DTS_IID>
<QUANTITY_IID>112</QUANTITY_IID>
<UNT_IID>94</UNT_IID>
</ROW>
<ROW>...</ROW>
</ROWSET>

The Column Update List has been set to
QUANTITY_IID INAME UNT_IID MEQ_IID INAME DESCR AODT DTS_IID QUANTITY_IID UNT_IID

The oracle error message
ORA-1400: cannot insert NULL into ("XX", "MEQ", "DESCR")
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2006
Added on Mar 10 2006
11 comments
7,502 views