ORA-01427

From: Braddini <braddini_at_yahoo.com>
Date: 18 Oct 2002 06:26:51 -0700
Message-ID: <f02626c6.0210180526.1087f912@posting.google.com>

anybody have a clue how to fiz this, i keep getting ORA-01427 error when i run the below query
UPDATE LMS.LIENS_TEST a
 SET (a.STATUS_ID, a.JOB_CODE, a.LIEN_DESC, a.CREATION_DATE, a.IPT_ID, a.DEPT_ID, a.CHANGE_DATE, a.CHANGE_ID) =

        (SELECT b.STATUS_ID, b.JOB_CODE, b.TITLE, b.CREATION_DATE,DECODE(b.IPT_ID,-999,DECODE(a.IPT_ID,-999,b.IPT_ID,a.IPT_ID),b.IPT_ID),

                DECODE(b.DEPT_ID,-999,DECODE(a.DEPT_ID,-999,b.DEPT_ID,a.DEPT_ID),b.DEPT_ID),
                b.CHANGE_DATE, vUSERID
          FROM LMS.LMSIMP_CMARS b, LMS.LMSIMP_LIEN_CODES c
          WHERE b.ROWID = c.ROW_ID
          AND c.LIEN_CODE = a.LIEN_CODE 
          AND b.LIEN_TYPE = vLIEN_TYPE 
          AND Not Exists (Select 1 From LMS.LMSIMP_ERRORS d WHERE

b.ROWID = d.ROW_ID))
 WHERE a.LIEN_TYPE = vLIEN_TYPE

    AND Exists (SELECT 1 FROM LMS.LMSIMP_CMARS b, LMS.LMSIMP_LIEN_CODES c

                    WHERE b.ROWID = c.ROW_ID AND c.LIEN_CODE =
a.LIEN_CODE AND b.LIEN_TYPE = vLIEN_TYPE
                    AND Not Exists (Select 1 From LMS.LMSIMP_ERRORS d

WHERE b.ROWID= d.ROW_ID)); Received on Fri Oct 18 2002 - 08:26:51 CDT