My Oracle Support Banner

TO_CLOB Returns Null (Doc ID 2600058.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

TO_CLOB returns null

SQL> SELECT b.MT_ZPRAVA
FROM (SELECT getTransactionData
       FROM (SELECT XML AS XML FROM scott.TEST_XML) t,
            XMLTABLE(XMLNamespaces(DEFAULT 'MQMTI.getTransactionRes',
                                   'http://schemas.xmlsoap.org/soap/envelope/' AS
                                   "soap"),
                     '/soap:Envelope/soap:Body/getTransactionResponse'
                     PASSING t.XML COLUMNS getTransactionData CLOB PATH
                     'getTransactionData')) a,
    TABLE(scott.test_xml_pck.parse_mt(inclob => to_clob(a.getTransactionData))) b;

no rows selected  ------>>>> incorrect

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.