Forum Stats

  • 3,816,531 Users
  • 2,259,202 Discussions
  • 7,893,505 Comments

Discussions

problem handling transaction across DB link

2712978
2712978 Member Posts: 8
edited Jul 14, 2014 6:00PM in JDeveloper and ADF

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

Sudipto Desmukh
This discussion has been closed.