Hi,

I need to delete all the data of a table from Oracle before insert data into it from BizTalk. I can't create stored procedure on the oracle table or how to create a xml of the delete schema of the oracle table in the BizTalk with filter node has a blank value because i need to delete all the data of the table so that i will send this xml as delete operation.

Thanks in advance.

Regards,

Gyan

You need to create two schemas: One for deleting all rows and one for inserting.

Then combine these Schemas into one and use the "CompositeOperation" SOAP Action Header.

Something like the below (a SQL Example, so the Schemas needs to be replaced by WCF-Oracle syntax)

<Request xmlns="http://CompositeTest.CompositeSchema">
  <Delete xmlns="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/Employee">
    <Rows>
      <Employee xmlns="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/dbo">
      </Employee>
    </Rows>
  </Delete>
  <Insert xmlns="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/Employee">
    <Rows>
      <Employee xmlns="http://schemas.microsoft.com/Sql/2008/05/Types/Tables/dbo">
        <Name>John</Name>
        <Designation>Manager</Designation>
        <Salary>100000</Salary>
      </Employee>
    </Rows>
  </Insert>
</Request>

Morten la Cour

Please change the thread type to Question instead of Discussion.

la Cour's answer above is correct.

Thanks for your reply

But i want to delete all the records from oracle from BizTalk then let me know how i create xml for that.

la Cour's answer is correct and complete, at least based on your problem scope.