Re: Update a Join View

"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 Received on Fri Oct 06 2006 - 16:19:49 CDT