This is probably the fastest method, though you can commit every X records to minimize commit overhead, and you can read the file into memory and write it to the database in one call through TLOBLocator.Write (instead of LoadFromFile).

To use an Insert statement without a returning clause, you can use a Temporary BLOB (TLOBLocator.CreateTemporary). This requires Direct Oracle Access 4.0.


Marco Kalter
Allround Automations