Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01427

Re: ORA-01427

From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 18 Oct 2002 13:00:38 -0700
Message-ID: <4306a83.0210181200.6eac395b@posting.google.com>


braddini_at_yahoo.com (Braddini) wrote in message news:<f02626c6.0210180526.1087f912_at_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));

I supose one of your subqueries returns more than one row. Try to run them alone. (You have to modify them a bit to join the LMS.LIENS_TEST) When you use er equal sign to an subquery, the subquery allways have to return one or none row(s). Received on Fri Oct 18 2002 - 15:00:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US