sql - Inserting into an XML column in DB2 database from Mulesoft flow -


i have xml column in db2 database table. i'm trying insert similar in mulesoft anypoint studio flow:

<db:insert config-ref="mydatabase" doc:name="database">      <db:parameterized-query><![cdata[insert schema.table         (my columns) values (:in1,:in2)]]>      </db:parameterized-query>      <db:in-param name="in1" type="varchar" value="load"/>       <db:in-param name="in2" type="sqlxml" value="#[some xml]"/>    </db:insert> 

no matter put in value of xml, comes sqlcode -407, saying field null. have tried using flow variable, using payload, using hard-coded value value="<hello/>">

thanks help.


Comments