From: kennedy-downwithspammersfamily@attbi.net   
      
    wrote in message   
   news:1111612303.901336.54150@g14g2000cwa.googlegroups.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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)