Re: SQL*Loader API

A copy of this was sent to abriggs5_at_my-deja.com (if that email address didn't require changing) On Tue, 11 Jan 2000 10:48:16 GMT, you wrote:

>Does anyone know if SQL*Loader has an API. If so
>what languages can be used. ?
>

sqlload does not have an API -- sqlloader is a tool that does INSERTS or direct path loads. Using OCI, Pro*c, plsql or any variety of languages -- you could write your own sqlloader tool...

In Oracle8.0 and before, you would use INSERT in any language to do what sqlldr does in a conventional path load.

In Oracle8i, release 8.1 and up, you have access to a C level API in OCI that allows you to do direct path loads as well.

>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 11 2000 - 06:52:07 CST