I have an xml doc that looks like this:
<RowSet>
<Row>
<Config>
<SubConfig>
...
</SubConfig
</Config>
</Row>
</RowSet>
Where Config is the column name (type CLOB), and all the inner xml is the value.
I'm calling DBMS_XMLStore like this:
xmlDoc CLOB := 'xml from above goes here';
rows := DBMS_XMLSTORE.insertXML(insCtx, xmlDoc);
However I get the following error:
ORA-19200: Invalid column specification
How do I insert values which are xml themselves?
No comments:
Post a Comment