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

From: Carlo Sirna <carlo.sirna_at_digisoft.it>
Date: Wed, 2 Apr 2003 12:20:25 +0200
Message-ID: <b6edhc$4h9ll$1@ID-135096.news.dfncis.de>

Hi, Yong

> Hi, Carlo, I can't reproduce. Let me know if I'm not doing it
correctly:

It seems you are doing it right... but it works differently on my server

>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> PL/SQL Release 8.1.6.1.0 - Production
> CORE 8.1.6.0.0 Production
> TNS for Solaris: Version 8.1.6.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production

and it seems the same version as mine

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Linux: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

I get the same problem also on 8.1.7... Received on Wed Apr 02 2003 - 04:20:25 CST