Fast bulk load with API?

[tacho...@gmail.com]

Hi all-

I have a windows service (like a Unix daemon) that loads flat files
into an 8.1.7 database. I use Oracle Objects for this, but it takes a
very long time, especially with CLOBs to do > 10,000 records. I would
use SQL Loader, but because this is a service, I can't spawn SQLLoader
to do the load for me.

Is there a SQLLoader-type API that I can call to do the same
functionality from within my program?

Thanks,

Ron

[Jim Kennedy]

<tacho...@gmail.com> wrote in message
news:1111612303....@g14g2000cwa.googlegroups.com...

Are you using bind variables in your program? (and leaving the cursors
open) If not that is why performance sucks.
Jim