DBMS_XMLSTore.insertXML with a value that is XML



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