Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How Can I write basic SQL Loader
Hi there!
I am a newcomer in Oracle!
Could anyone tell me how to write a stored procedure in PL/SQL to load data from a
formatted file into a table?
I had already try using sqlldr and it work quite well. But now I want to know how
to do it using a stored procedure
thanks
Bea
Thomas Kyte a écrit :
> 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 Wed Jan 12 2000 - 08:42:50 CST