problem handling transaction across DB link

2712978

Hello,

Usecase :

Do crud operation on two tables from different schema's. Both schema's are accessed using single DB user credential via DB Link. Now when user tries to create a record on ADF UI, a transaction is initialised in ADF and at DB level in both schema. If user does nothing .....transaction time out is going to close the DB transaction in first schema... but how to handle the transaction in second schema which exist because of DB Link.

Thanks