I have an XMLType column containing XML Data.
one of the tag names is <ns4:ContactFullName>.
I would like to extract the value from that element. First I need to select the row which contains the xmltype data that I want to extract from.
My query looks like this:
SELECT EXTRACTVALUE(VALUE(x) , '\ns4:ContactFullName')
FROM table_name, XMLTABLE(XMLSEQUENCE(EXTRACT(xmltype( SELECT xmltype_column from table_name where COLUMN1 = 10 and COLUMN2= 'somestring' and COLUMN3 ='N'), '\\ns4:ContactFullName'))) x
I am getting this error:
An exception was thrown: ORA-19102: XQuery string literal expected
any help would be appreciated.