10g: Update a Join View

From: klabu <klabu76_at_gmail_dot_com>
Date: Fri, 6 Oct 2006 17:02:44 -0400
Message-ID: <12idh3l6n195ve8@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 Received on Fri Oct 06 2006 - 16:02:44 CDT