selecting from an Object View starts a transaction???

From: Carlo Sirna <carlo.sirna_at_digisoft.it>
Date: Mon, 31 Mar 2003 17:37:30 +0200
Message-ID: <b69nbt$1uus3$1@ID-135096.news.dfncis.de>

Hi!

I have an object view called v_banca.

I have noticed that every time I access this object view oracle
(8.1.6) does start a transaction.

  take a look at this example:

SQL> select sys.dbms_transaction.local_transaction_id from dual; LOCAL_TRANSACTION_ID

---

(there is no active transaction id, but if I try to access this object
view...)

SQL> select count(*) from v_banca;
COUNT(*)

---

         3

SQL> select sys.dbms_transaction.local_transaction_id from dual; LOCAL_TRANSACTION_ID

---

16.1.7453

A new transaction has started... I understand that there could be a good reason for this... but I can't really focus it... Does anybody have an explaination for this?

Thanks,
  Carlo Sirna Received on Mon Mar 31 2003 - 09:37:30 CST