Thu, 23 Mar 2023 14:54:50 -0600, /Russell Bateman/:

In fact, experimentation seems to suggest that the breaking point is a length of 32K+.

This seems to match the VARCHAR and LONG VARCHAR specifications:


This happens to be the string literal in your INSERT statement. If you want to insert more than 32K in your CLOB column you would need to use the JDBC interfaces:

*,,int) *,,long)

and for reading:

* *

– Stanimir

On 3/23/23 13:02, Russell Bateman wrote:

According to what I'm reading, a CLOB should easily hold more than the 128K I'm trying to put into it.

My insert string:

    INSERT INTO ssdi_small_tbl( MsgContent, MsgReceived, MsgSource,
    MsgFacility, MsgType1, MsgType2, MsgAltId1, MsgAltId2, MsgMisc1,
    MsgStatus, MsgStatusDate, MsgStatusInfo )
            '<?xml version="1.0" encoding="UTF-8"?>
    <ClinicalDocument xmlns="urn:hl7-org:v3"
                ...about 128K of well formed XML...


Reply via email to