Remote Select opening transaction

From: Marc Demlenne <marc.demlenne_at_gmail.com>
Date: Tue, 3 Apr 2007 14:07:34 +0200
Message-ID: <a25b91ba0704030507i22284b7bh9365c71b35018ec9@mail.gmail.com>

Hello,

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,

--

Marc

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 03 2007 - 07:07:34 CDT