#71 Errors with long colums over 4096 characters.

[Todd Helfter]

My production version of Oracle:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

I also see the same behavior with:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

FYI, I am using the 32-bit Oracle libraries in my code:

set env(ORACLE_LIBRARY) "$env(ORACLE_HOME)/lib32/libclntsh.so"

I have a production problem where an Oracle LONG value is being truncated — that is, the production tcl code is not retrieving the entire field, which I determined (by using ‘sqlplus’) is just over 56,000 characters long. The field contents are straight ASCII-7 characters, as far as I know — nothing fancy like Unicode, etc.

The ‘oraconfig longsize’ setting in the production tcl script was set to 10 million, much longer than any expected data:

oraconfig $cursor longsize 10000000

(I tried using a much smaller longsize of 100000. No joy.)

I can duplicate the problem at will. I created a test Oracle table with a single LONG field:

Troy Evans

[Todd Helfter]

I have been able to recreate the error and have a bug fix prepped.

[Todd Helfter]

commited patch the CVS head.