Help with single-row subquery returns more than one row. [message #357676] |
Thu, 06 November 2008 04:09  |
ch_praveen2007
Messages: 1 Registered: November 2008
|
Junior Member |
|
|
Hi All,
I'm using this query to find the records which have A.ID column as NULL and insert into the ACTIVITY table with the criteria as ID, NUM, STAT, ACTIVITYID and BU.
INSERT INTO ACTIVITY
(ID, NUM, STAT, ACTIVITYID, BU)
SELECT ROWNUM,
6112008,
'UNDER_PROGRESS',
ACTIVITYID,
(SELECT NAME
FROM BU
WHERE ID IN
(SELECT ID
FROM POSTN
WHERE EMPID IN (SELECT ROW_ID FROM USER WHERE ROW_ID = EMP_ID)))
FROM ACT A, ACT_EMP B
WHERE A.ID = B.ACTIVITYID
AND A.ID IS NULL
This query returns an error showing
ORA - 01427 : single-row subquery returns more than one row.
Please help me out with this issue.
Thanks In Advance.
Praveen.
|
|
|
|
|
|
|
Re: Help with single-row subquery returns more than one row. [message #358127 is a reply to message #357676] |
Sat, 08 November 2008 20:04   |
shobanasree
Messages: 9 Registered: November 2008 Location: Bangalore
|
Junior Member |
|
|
Hi Praveen,
Use cursor to select the below statement.
SELECT ROWNUM,
6112008,
'UNDER_PROGRESS',
ACTIVITYID,
(SELECT NAME
FROM BU
WHERE ID IN
(SELECT ID
FROM POSTN
WHERE EMPID IN (SELECT ROW_ID FROM USER WHERE ROW_ID = EMP_ID)))
FROM ACT A, ACT_EMP B
WHERE A.ID = B.ACTIVITYID
AND A.ID IS NULL
Inside the for loop or Open cursor loop write the insert statement.
Now your query should work fine.
|
|
|
|