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

Sorry about the delay in replying.
I've tried this on 8.1.7.4 (inserting a
couple of rows into BANCHE just
after creating the table) and don't
get a transaction started on a
  'select count(*) from v_banca'

--
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:b6bk2e$3iotg$1_at_ID-135096.news.dfncis.de...


> There really isn't for what I can see a good reason to start a

> transaction. The view does simply rename the columns of a table...

and


> does not contain any ref column:

>

> these are the definitions of the table, of the type and of the view

> involved:

>

>

> create table BANCHE

> (

>     BAN_COD VARCHAR2(11) not null,

>     BAN_DESC VARCHAR2(64),

>     BAN_SPOR VARCHAR2(50),

>     BAN_ABI VARCHAR2(5),

>     BAN_CAB VARCHAR2(5)

> )

> /


...