You can see in Oracle Error message what is wrong, that is very clearly. Try to execute query with your WHERE clause and get count(*) > 1.

Originally posted by raf
ORA-01427 - single-row subquery returns more than one row