Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update a Join View
Surely you jest, Sir?
Robbert van der Hoorn wrote:
> "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
> >
>