using evalname results in ORA-0600
Rick JApr 4 2008 — edited Apr 5 2008The following query throws an ora-0600 if I use the evaluate option in XMLELEMENT. It executes successfully when evalname is removed. My database is 10.2.0.3.
WITH geom_info AS
(SELECT fsv_id,
XMLELEMENT ("GEOM",
XMLTYPE (sdo_util.to_gmlgeometry (g.geom))
) AS geom_xml
FROM feature_geometries g),
att_info AS
(SELECT a.fav_id, XMLELEMENT (attributetype, att_value) AS att_xml
FROM feature_attributes a)
SELECT XMLELEMENT
("gml:featureMember",
XMLELEMENT (evalname (objecttype),
xmlattributes (id AS "fid")
),
geom_xml,
att_xml
) AS "gml"
FROM tempfeatures v,
geom_info g,
att_info a
WHERE v.foid = f.foid
AND g.fsv_id = v.fsv_id
AND a.fav_id(+) = v.fav_id;
ORA-00600: internal error code, arguments: [qmxtcCreateCreateIdn :lxXmlIdCon],
[], [], [], [], [], [], []
Am I using this option incorrectly?
Does anyone have any other suggestions a what I could do as an alternative to get the resulting dynamically tags defined by the results of the query?
Thanks,
Rick