You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to remove duplicate tags from XML


Summary: I am facing some issue while using UTL_HTTP rest service package we are getting some duplicate tags in client xml file which is causing issue to do sql

Error : ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

Content (required): Sql query to fetch data

SELECT tab1.contact_email FROM xxbcg_coupa_xml_gtt gtt,XMLTABLE

( '/easy-form-responses/easy-form-response[name="ABC-FORM"]'

      PASSING xmltype (gtt.xml_data)      COLUMNS contact_email VARCHAR2 (4000)

 PATH '//subject/supplier-information-contacts/supplier-information-contact/email',

XMLTYPE  PATH '//subject/supplier-information-addresses/supplier-information-address') tab1;

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!