Hi
DB version 11.2.0.1
I have clob with name "a" in table dummy_clob which include XML date, i need to select this data but there is error apper ORA-19228: XPST0008
Query:
SELECT x.Cba_Number,x.Reference_Id
FROM dummy_clob t,
XMLTABLE (
'/ns2:SearchResponseType xmlns:ns2="##default" xmlns="urn:com.xxx:xxx:xxx:1"'
PASSING xmltype (t.a)
COLUMNS Cba_Number VARCHAR2 (2000) PATH 'CbaNumber',
Reference_Id VARCHAR2 (2000) PATH 'ReferenceId') x
XML:
<ns2:SearchResponseType xmlns:ns2="##default" xmlns="urn:com.xxx:xxx:xxx:1">
<CbaNumber>29291618</CbaNumber>
<ReferenceId>123459</ReferenceId>
</ns2:SearchResponseType>