OracleXMLSave how to insert empty string
497467Mar 10 2006 — edited Mar 16 2006We 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")