Skip to Main Content

SQL & PL/SQL

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!

retrieve an xml value. LPX-00601: Invalid token in: 'Image Information' 310

927867Oct 30 2012 — edited Oct 30 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2012
Added on Oct 30 2012
7 comments
2,035 views