3/2/01 - ORA-01767 on UPDATE

From: Gorden-Ozgul, Patricia E <gorden_at_bnl.gov>
Date: Fri, 02 Mar 2001 13:51:49 -0800
Message-ID: <F001.002C2D92.20010302135117@fatcity.com>

Here's my code

update copy_rec_out_test
set

(copy_rec_out_test.sirsi_949m,

        copy_rec_out_test.sirsi_949l,
        copy_rec_out_test.sirsi_949k,
        copy_rec_out_test.sirsi_949t,
        copy_rec_out_test.sirsi_949x,
        copy_rec_out_test.sirsi_949z)

=
select (matrix.sirsi_949m,

        matrix.sirsi_949l,
        matrix.sirsi_949k,
        matrix.sirsi_949t,
        matrix.sirsi_949x,
        matrix.sirsi_949z)
where


        (matrix.libr_key,

        matrix.avlb,
        matrix.mtype,
        matrix.ctype)
=


        (copy_rec_out_test.libr_key,

        copy_rec_out_test.avlb,
        copy_rec_out_test.mtype,
        copy_rec_out_test.ctype)
where exists


        (select 1 from matrix

        where


        (matrix.libr_key,

        matrix.avlb,
        matrix.mtype,
        matrix.ctype)
=


        (copy_rec_out_test.libr_key,

        copy_rec_out_test.avlb,
        copy_rec_out_test.mtype,
        copy_rec_out_test.ctype)

/

......................................................................

I'm getting ORA_01767: UPDATE ...SET expression must be a subquery on execution.

Have you any idea what I'm doing wrong?
Much appreciated.

Pat

---

Pat Gorden-Ozgul               BNL-ISD Systems
gorden_at_bnl.gov                 631-344-5159

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorden-Ozgul, Patricia E
  INET: gorden_at_bnl.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Mar 02 2001 - 15:51:49 CST