Hi,dblack,
I am using the below format:
<root>
<bizcomp1/>
<bizcomp2/>
</root>
Here is the XBD as explained:
<Document>
<sql XBC read data from table>
<file XBC write
XML as in file>
<sql XBC insert the record in table of another database>
<Document>
I also tested only the writing sql XBC, inputting the XML file, got the same error; when remove the BLOB mapping, the record got inserted successfully.
Thanks & Regards
-----------------------
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns:xa="http://xaware.org/xas/ns1" xa:version="5.0" xa:on_error="xa-doc::/Document/Error" xa:visible="yes">
<xa:input>
<xa:param xa:name="file_type" xa:datatype="string" xa:default="826" xa:description="" />
<xa:param xa:name="cus_mst_no" xa:datatype="string" xa:default="2525632" xa:description="" />
<xa:param xa:name="filetoWrite" xa:datatype="string" xa:default="C:\Applications\xaware\designer\workspace\TFGT\data\file1.xml" xa:description="File XML will be written to" />
</xa:input>
<get_dbt_c_in_file xa:bizcomp="myService/dbt_c_in_file.xbc" xa:remove="yes" file_type="%file_type%" cus_mst_no="%cus_mst_no%" />
<writetoxml xa:bizcomp="myService/writeXML.xbc" xa:input="xa-doc::/Document/DBT_C_IN_FILE" xa:remove="yes" filetoWrite="%filetoWrite%" />
<Update_dbt_c_in_file xa:bizcomp="myService/insert_dbt_c_in_file.xbc" xa:input="xa-doc::/Document/DBT_C_IN_FILE" xa:remove="yes" />
<Error xa:include="no">
<detail>$xavar:error_stack$</detail>
</Error>
</Document>
-----------------------------------