Remote Select opening transaction
Remote Select opening transaction -- Marc Demlenne 2007-04-03
In Oracle 8, when performing a select query on another database threw DB link, Oracle opens a transaction that could only be closed by commit or rollback. That could be harmful when developers are not aware of this and don't close transaction. (leading to ORA-01562.)
What is the reason of this behaviour ? Is there some docs / faq explaining this ?
Is this feature also common to later versions of Oracle ?
Thanks a lot for any piece of information given,