Re: Single Row Subquery Returns More Than One Row

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: 19 Oct 2001 12:27:05 -0700
Message-ID: <605a2fd5.0110191127.5b76805f_at_posting.google.com>


> 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.

It means your select statement is returning more than one row and since you are trying to set task_instance_id equal to some value, it has to be a single value. Change your where clause so that only one row is returned (or fix your data). Received on Fri Oct 19 2001 - 21:27:05 CEST

Original text of this message