SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01427: single-row subquery returns more than one row tips

Augustine VinishApr 30 2012 — edited Apr 30 2012

Hi Team ,

I have two different set of select query which contains sub query also .

While I combining this two Select statement by UNION command I am getting this Error Mesaage

ORA-01427: single-row subquery returns more than one row tips in the Procedure .

Could you please help to find out which sub query is causing this failure .

Any code change or adding DBMS_OUTPUT can helpful for me .Please mention me some programs logic to watch the error

Regards
Augustine

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2012

Added on Apr 30 2012

#pl-sql, #plsql, #sql

5 comments

5,359 views