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!

LPX-00231: invalid character 62 ('>') found in a Name or Nmtoken

402949Jun 25 2007 — edited Jun 26 2007
When 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2007
Added on Jun 25 2007
1 comment
2,055 views