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

"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

Does the view reference any object in a remote database?

Yong Huang Received on Mon Mar 31 2003 - 13:49:38 CST