Re: Is the a programming interface/API for SQL*Loader?

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Mon, 22 Jan 2001 23:10:56 GMT
Message-ID: <3a6cbd64.3992621@newshost.interact.net.au>

On Mon, 22 Jan 2001 02:24:49 GMT, "Jim Kennedy" <kennedy-family_at_home.com> wrote:

>You could use a variety of methods.(from slowest to fastest - given proper
>programming)
>ODBC
>ADO
>Oracle's OLE objects
>OCI
>to name a few.
>Jim

OK, ODBC doesn't support any SQL*Loader functions, and Oracle's OLE DB provider doesn't implement the iRowsetFastload method, so no bulk inserts for those two (only labourious one-at-time inserts). OO4O doco talks a little about array inserts, but I'm sure this won't be as fast as SQL*Loader ... but I'll take a look.

Ciao
Fuzzy
:-) Received on Mon Jan 22 2001 - 17:10:56 CST