Skip to Main Content
Forums

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!

Error : ORA-00913: too many values

696393Mar 22 2012 — edited Mar 22 2012
A subqury inside IN block fetch two id's ( 252621,325645) but the query is erroring out , please tell me what causing this issue

select comments from oa_rce_bo
where  e_id in(
SELECT to_char(ta_id),to_char(id) FROM gdb_s_mtr WHERE ID = TRIM (3049413) OR oa_id = TRIM (3049413)
)
Error : ORA-00913: too many values
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2012
Added on Mar 22 2012
6 comments
1,916 views