Hi experts,
Got an issue here in retrieving an xml value.
Trying to figure out what happened but got no clue..
error message:
LPX-00601: Invalid token in: 'Image Information'
31011. 00000 - "XML parsing failed"
*Cause: XML parser returned an error while trying to parse the document.
*Action: Check if the document to be parsed is valid.
My script:
select material_id, name
, material_util.get_path(material_id, material_type_id, 1007535, null, 1) as mat_bm_path
, description "Description"
, extract(xmltype.createxml(fields_xml), '//field[1]/text()').getStringVal() as Image_Information
from material
where (material_id, material_type_id) in(select nfx_link, nf_materialtypeid
from materialfolder
where nf_folderid in(select ip_folderid as folder_id
from folder
start with ip_folderid = 1007535
connect by nf_parentfolderid = prior ip_folderid
and ip_folderid != prior ip_folderid)) ;
Here is one example value for fields_xml:
<?xml version="1.0" encoding="UTF-8"?><fields><field maxlength="2000" name="Image Information" required="true" type="textarea">49 x 33cm @300dpi</field></fields>
Regards,
JP