Posted By: El Fetch XMLTYPE on demand - 10/18/21 10:19 AM
Hello:

Parameter "Fetch CLOBs and BLOBs on demand" does not take xmltypes. Is there a way to make me contemplate them?

Best Regards,
Posted By: Marco Kalter Re: Fetch XMLTYPE on demand - 10/19/21 09:09 AM
This setting does indeed not apply to xmltype fields. It does work however if you use the getclobval() function. For example:

select id, x.xml.getclobval() as xml_clob from my_xml_table x
© Allround Automations forums