Page 1 of 1

Error In Update Assignment API

Posted: Sun Oct 02, 2011 5:20 am
by dammur
I am using the assignment API to update the position and other information for an employee but it is giving me the error as

"ORA-01427: single-row subquery returns more than one row".

any help is greatle appreciated.its very urgent

Thanks.

Posted: Tue Dec 06, 2011 4:27 am
by rahuldwivedi
Dear,

Are you using any kind of sub query in your code. If yes then check that, as it may be returning multiple rows for which it is failing.

Posted: Wed Dec 07, 2011 7:34 am
by eng_ahmad_2007
As Rahul said,

Your Subquery is returning too many rows... check it and make it return a single row