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):