Skip to Main Content

Database 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!

using evalname results in ORA-0600

Rick JApr 4 2008 — edited Apr 5 2008
The 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2008
Added on Apr 4 2008
1 comment
1,222 views