Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update a Join View
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
> >
>
>