Fast bulk load with API?

[tachoknight@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]

Re: Fast bulk load with API?


<tachoknight@gm ail.comwrote in message
news:1111612303 .901336.54150@g 14g2000cwa.goog legroups.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
>

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