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
Re: Fetch XMLTYPE on demand
El
#62721
10/19/21
09:09 AM
Joined:
Aug 1999
Posts: 22,221
Marco Kalter
Member
Marco Kalter
Member
Joined:
Aug 1999
Posts: 22,221
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
Entire Thread
Subject
Posted By
Posted
Fetch XMLTYPE on demand
El
10/18/21
10:19 AM
Re: Fetch XMLTYPE on demand
Marco Kalter
10/19/21
09:09 AM
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 Flat Mode
Show Likes
Link Copied to Clipboard
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.160s
Queries:
15 (0.134s)
Memory:
2.5244 MB (Peak: 3.0437 MB)
Data Comp:
Off
Server Time:
2024-05-20 17:54:20 UTC
Valid HTML 5
and
Valid CSS