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
[EMAIL PROTECTED] 631-344-5159
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gorden-Ozgul, Patricia E
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
