LPX-00231: invalid character 62 ('>') found in a Name or Nmtoken
402949Jun 25 2007 — edited Jun 26 2007When looping through this cursor:
CURSOR c_xml (b_xmltype XMLTYPE)
IS
SELECT extractvalue(value(t),'//site_name') AS site_name
,extractvalue(value(t),'//ste_id') AS ste_id
,extractvalue(value(t),'//plant_name') AS plant_name
,extractvalue(value(t),'//unit_name') AS unit_name
,extractvalue(value(t),'//tag_no') AS tag_no
,extractvalue(value(t),'//tag_type') AS tag_type
,extractvalue(value(t),'//tag_active') AS tag_active
,extractvalue(value(t),'//eqt_equipment_no') AS eqt_equipment_no
,extractvalue(value(t),'//eqt_active') AS eqt_active
,extractvalue(value(t),'//eqt_type') AS eqt_type
,extractvalue(value(t),'//eqt_description') AS eqt_description
FROM TABLE(XMLSequence(EXTRACT(value(b_xmltype), '/Assets/Asset'))) t;
I get the above error. The variable b_xmltype is an XML message which contains special characters like <>, &. I'd like to have these characters printed in a file.
How to circumvent this error ??
Thanks in advance,
Job Rietsma