How do I pull individual XML values from an existing BLOB

158 Views Asked by 2020 Fraud At 25 August 2022 at 20:18

I have a blob which I don't own and cannot change. It is a BLOB containing an XML message which I want to parse.

My parse attempt is as follows:

SELECT
   XMLTYPE( t.intfc_rqst_xml ).EXTRACT('//*/text()').getStringVal() 
FROM
   INTERFACE_MESSAGE_INFO t;

Gives this Error

ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'

Any help appreciated!

There are 1 best solutions below

Yitzhak Khabinsky On 25 August 2022 at 20:28 BEST ANSWER

Character set is a second parameter.

You can try the following:

...
xmltype(t.intfc_rqst_xml , nls_charset_id('AL32UTF8'))
...

Different Character Sets