Re: Update a Join View

"The Flying Spontinalli" <wolf__at_tiscali.co.uk> schreef in bericht news:1160305021.202446.159970_at_k70g2000cwa.googlegroups.com...
> You can't create an instead-of trigger on an inline view.
>
> Robbert van der Hoorn wrote:
>> "klabu" <klabu76_at_gmail_dot_com> schreef in bericht
>> news:12idh3l6n195ve8_at_corp.supernews.com...
>> >
>> > 10gXE
>> > I get error "ORA-01776: cannot modify more than one base table through
>> > a
>> > join view"
>> > while testing the SQL below...
>> > Is there a way to get around this ?
>> >
>> > thanks
>> >
>> > -------------------------------------------------------------------------
>> > scott_at_XE> alter table emp add (dname varchar2(14));
>> >
>> > Table altered.
>> >
>> > scott_at_XE> update emp set dname = 'COKE';
>> >
>> > 14 rows updated.
>> >
>> > scott_at_XE> commit;
>> >
>> > Commit complete.
>> >
>> > scott_at_XE>
>> > 1 UPDATE
>> > 2 (SELECT me.dname medname, md.dname mddname
>> > 3 FROM
>> > 4 emp me, dept md
>> > 5 WHERE me.deptno = md.deptno
>> > AND empno = 7369 )
>> > 6* SET medname = 'BEER', mddname = 'WINE'
>> > *
>> > ERROR at line 6:
>> > ORA-01776: cannot modify more than one base table through a join view
>> >
>>
>> Klabu,
>>
>> yes you can, take a look at instead-of triggers!
>>
>> Robbert van der Hoorn
>> OSA it BV
>> The Netherlands
>

You're right, but why not create an explicit view when wanting to update?

Robbert Received on Sun Oct 08 2006 - 17:04:19 CDT