Print Thread
Fetch XMLTYPE on demand
#62718 10/18/21 10:19 AM
Joined: Sep 2019
Posts: 34
Spain
E
El Offline OP
Member
OP Offline
Member
E
Joined: Sep 2019
Posts: 34
Spain
Hello:

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

Best Regards,


-------------------------------
Elias F.M.
Re: Fetch XMLTYPE on demand
El #62721 10/19/21 09:09 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
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


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.114s Queries: 14 (0.093s) Memory: 2.4941 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-27 19:06:48 UTC
Valid HTML 5 and Valid CSS