Page 1 of 1

TOraLoader and BLOB columns

Posted: Tue 11 Apr 2006 06:54
by ramajana
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.

Posted: Tue 11 Apr 2006 11:43
by Alex
With TOraLoader you can't load LOBs (except through String values). Use multiple INSERT statements instead.