Large table loader

[somis]

I am use the TOracleDirectPathLoader ,
Have a large text file and need load into a
table.

I learning the doa's demo --DirectPath, found
needing declare collection for save the text
records, but because the text file is so large, so exeute program use all memory

also, need declare record struct is distracted working, because the table's field
more(80), defined the records struct is faint
and the programing code with database table relatively tightness.

Haveing any method avoid defined the record
struct? like ODAC's method.

 

[Marco Kalter]

It is not necessary to use a Collection, but you must have the data in memory somewhere before you can load it. You should not load all data into memory, but should divide it into batches of records. Just like in the demo.

------------------
Marco Kalter
Allround Automations