Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
but am geting the error above am in form 11gR2 AND MY DATABASE is 11gR2 my query run well in my sql developer
select c.obj_name , obj_childs, obj_parents,d.Obj_type ,d.description,d.sub_system from (select obj_name,RTRIM(EXTRACT(XMLAGG(XMLELEMENT("x",obj_child || ',') order by obj_child), '/x/text()').getclobval(), ',') obj_childs from (select distinct c.obj_name, oc.obj_name obj_child from cal_obj c, cal_erd_link ec, cal_obj oc where ec.obj_parent(+) = c.obj_name and ec.obj_child = oc.obj_name(+) ) group by obj_name ) c , (select obj_name, RTRIM(EXTRACT(XMLAGG(XMLELEMENT("x",obj_parent || ',') order by obj_parent), '/x/text()').getclobval(), ',') obj_parents from (select distinct c.obj_name, op.obj_name obj_parent from cal_obj c, cal_erd_link ep , cal_obj op where ep.obj_child(+) = c.obj_name and ep.obj_parent = op.obj_name(+) ) group by obj_name ) p , cal_obj d where c.obj_name = p.obj_name and d.obj_name = c.obj_name
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.