CLOBs have a limit of 2000 bytes? That doesn't sound right to me. I thought CLOBs could be very large, I thought it was regular varchar columns that were limited in size.

From: [] On Behalf Of Ryan Puddephatt
Sent: April 30, 2008 02:09
To: Mailing list for the SAXON XSLT and XQuery processor
Subject: ***SPAM*** Re: [saxon] Creating a .Net Extension function


                I totally agree that XPath is the best way to manipulate nodes, but I’m using XSL to create an Oracle scripts that inserts XML into a database, unfortunately CLOBs have a limit of 2000 bytes so I need to split the XML into strings of 2000 bytes and then copy them back in, I’ve found that this would work for getting the node passed from Saxon, and then I can use OuterXml to get the value string value


        public static Array SplitXml(XPathContext c,object node) {


            if(node is System.Xml.XmlLinkedNode) {






Ryan Puddephatt

FIX Developer

Fidessa LatentZero

1 Alfred Place

London WC1E 7EB

t: +44 (0) 20 7323 6112

b: +44 (0) 79 8539 2458

f: +44 (0) 20 7462 4242