Skip to Main Content

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!

Getting a ORA-01417 error. Could anybody look at this?

567078May 29 2007 — edited May 29 2007
select * from (select
d.ecev_tag ecev_tag,
a.digp_tag entity_owner ,
c.digp_tag task_owner,
c.tk_tag task_tag,
c.due_date,
c.narrative
from enow a,
entl b,
tk c,
ecev d ,
(SELECT distinct parent_digp_tag
from
(
SELECT parent_digp_tag, child_digp_tag
FROM dghi
START WITH child_digp_tag=100
CONNECT BY PRIOR parent_digp_tag= child_digp_Tag)) e
where ( a.DIGP_TAG=100 or c.digp_tag=100 or a.digp_tag=e.parent_digp_tag or c.digp_tag=e.parent_digp_tag)
and a.entity_tag=b.entity_tag(+)
and b.tk_tag=c.tk_tag(+)
and a.entity_tag=d.ecev_tag
and a.cept_tag=c.cept_tag(+)

I am getting..
and b.tk_tag=c.tk_tag(+)
*
ERROR at line 21:
ORA-01417: a table may be outer joined to at most one other table



Thanks
Ram
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2007
Added on May 29 2007
6 comments
273 views