Re: Single Row Subquery Returns More Than One Row
Date: Fri, 19 Oct 2001 16:30:29 GMT
Message-ID: <FyYz7.74525$5h5.31372990_at_news3.rdc2.on.home.com>
Your subselect is returning more than one value redefine your query to return a unique value.
run this part of your rqiuery and see the number of values returned.
SELECT A.TASK_INSTANCE_ID
FROM TBLTASK_INSTANCE A, TBLEWC_TASK_INSTANCE B WHERE A.TASK_ID IS NULL AND B.TASK_INSTANCE_ID IS NULL AND A.EWC_INSTANCE_ID = B.EWC_INSTANCE_ID
It like saying
update table
set field = a,b,c .... e
Which value does it pick ?
"Kevin" <matthewsKE_at_MCCDC.USMC.MIL> wrote in message
news:5139d091.0110190632.474c3df7_at_posting.google.com...
> I am trying to update a table with the following query.
>
> UPDATE TBLEWC_TASK_INSTANCE
> SET TASK_INSTANCE_ID =
> (
> SELECT A.TASK_INSTANCE_ID
> FROM TBLTASK_INSTANCE A, TBLEWC_TASK_INSTANCE B
> WHERE A.TASK_ID IS NULL
> AND B.TASK_INSTANCE_ID IS NULL
> AND A.EWC_INSTANCE_ID = B.EWC_INSTANCE_ID
>
> )
>
> I keep getting the following error message: ORA-01427 Single row
> subquery returns more than one row.
>
> If any one has seen this before please let me know.
>
> Thanks!
>
> Kevin
Received on Fri Oct 19 2001 - 18:30:29 CEST