TOraLoader and BLOB columns

ramajana · Post by **ramajana** » Tue 11 Apr 2006 06:54

Hello,
I can't get TOraLoader to import a blob value. I can have it imported as string (TDPColumn.DataType := ctString), but this doesn't work well for large values. For example, if I use size of 4000, I can succesfully import blob up to that size. But if I want to import images, each of several MB, I run into problems. Tried setting length of such string column to maximum size of blobs in the table, but this throws memory exception.

Any ideas?

Thanks.

Alex · Post by **Alex** » Tue 11 Apr 2006 11:43

With TOraLoader you can't load LOBs (except through String values). Use multiple INSERT statements instead.