Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
PL/SQL Developer
Fetch XMLTYPE on demand
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
Fetch XMLTYPE on demand
#62718
10/18/21
10:19 AM
Joined:
Sep 2019
Posts: 34
Spain
E
El
OP
Member
OP
El
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.
Copy Link to Clipboard
Re: Fetch XMLTYPE on demand
El
#62721
10/19/21
09:09 AM
Joined:
Aug 1999
Posts: 22,206
Marco Kalter
Member
Marco Kalter
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
Copy Link to Clipboard
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
Plyxon Alpha / Beta
PL/SQL Developer 15.0 Beta
Print Thread
Switch to Threaded Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
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