Analytics Software

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!

Error ORA-1427: single-row subquery returns more than one row

567066Oct 26 2009 — edited Oct 27 2009

Gurus,

I have a custom view and this view is running corretly and getting the required date when run in toad or sqlplus.

if I run the same view in Discoverer, I am getting the below error
ORA-1427: single-row subquery returns more than one row

Any idea would could be the reason why I am getting this error is discoverer, But the same view is working correctly in toad? Please advice

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2009

Added on Oct 26 2009

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

4 comments

4,949 views