XML to CLOB & UTF-8 Queries

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: XML to CLOB & UTF-8 Queries

Postby Tim... » Mon Jun 18, 2012 3:35 pm


In that case you may be hitting a limitation with the XML functionality. I believe some of the XMLTYPE functions are limited to 64000 bytes at the moment. I'm assuming the SQL/XML is processing this information using XMLTYPEs, so it may never work on large documents.

You should raise an SR with Oracle Support to check this.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Balaji Krishnan
Posts: 20
Joined: Fri Mar 30, 2012 3:03 pm

Re: XML to CLOB & UTF-8 Queries

Postby Balaji Krishnan » Mon Jun 18, 2012 6:28 pm


I was able to create XML CLOBs in my local database without any such issues on large documents(50K records) using SQL/XML functions. Suddenly this issue is occurring today in my local m/c. It may go fine in other environments. I will give it a try and let you know. Thanks for your guidance and support.

Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 2 guests