Re: Help: Data in LONG column truncated to 100 chars.

Hi Dave,

I checked the Oracle OLEDB Provider guides for 8i and 9i and you are correct in saying that the maximum chunk size you can set is 64K. The default is 100 bytes. So this "solution" really just shifts the problem. Odd that it accepts the 2GB value.

The next thing I tried is multiple calls to GetChunk on the LONG field. Using the MSDAORA provider this works perfectly. However, with ORAOLEDB.Oracle, it seems to forget the position within the field, yet retains the fact it has returned some information. In other words , it always returns the data at the start of the field up to a maximum of the ChunkSize setting.

e.g. Let's say the chunk size is the default of 100 bytes and that fld

     points to a LONG column within a recordset, then (in VBScript)

dim str

str = fld.GetChunk (40)         ' returns the first 40 characters
str = str & fld.GetChunk (40) ' appends the first 40 characters
str = str & fld.GetChunk (40) ' appends the first 20 characters

This must be a fault in the Oracle provider

--
Posted via http://dbforums.com