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
Post a Comment