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

From: <hailey_kyle_at_my-deja.com>
Date: Tue, 23 Jan 2001 22:56:35 GMT
Message-ID: <94l26u$o4g$1@nnrp1.deja.com>

Hearing sqlldr I assume you want access to direct load and unrecoverable which is what really makes loader great - new in 8.1.6 there is a direct load API in OCI, see the 8.1 docs

In article <3a6cbd64.3992621_at_newshost.interact.net.au>, granta_at_nospam.student.canberra.edu.au (Fuzzy) wrote:
> 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
> :-)
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 23 2001 - 16:56:35 CST