Re: selecting from an Object View starts a transaction???

This type of behaviour is not reproducing on my version of Oracle (alas, I don't have an 8.1.6). Is there something about the object view which might be causing a real transaction to start ?

What does the definition of the object view look like ?

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 8th
____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Carlo Sirna" <carlo.sirna_at_digisoft.it> wrote in message
news:b69nbt$1uus3$1_at_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

>

>