We use WCF-oracle adapter to connect to our backoffice oracle databases to insert data into order header and order detail tables directly . We do not have delete permissions on these tables.
We first insert data into header using send port and then into detail . Sometimes order header gets inserted correctly but there are issues while inserting data to detail and hence the order is incomplete . From biztalk we want to make sure insertion into header and detail happens in one transaction ( either commit or rollback ) . How can we achieve this using Biztalk WCF-oracle sql adapter ? Please advise.