Fetch XMLTYPE on demand

[El]

Hello:

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

Best Regards,

 

[Marco Kalter]

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