i have used explicit transaction like this
insert (local trasaction, connect to db1)
update (no transaction, connect to db2)
i am getting the specified exception
Error ART.117.4011 Unable to connect to resource .The resource is already being used in a parent transaction.
As per my understaing we can not use two local transactions in one explicit transaction.
if i create a seperate flow and use explicit transaction for insert service and called up into the current explict transaction, if insert is success then it will commits the transaction even though update fails.
I want to roll back insert service if update fails.
can you please help me out.