Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How Can I write basic SQL Loader

How Can I write basic SQL Loader

From: Beatrice Juniel <bjuniel_at_sit.fr>
Date: Wed, 12 Jan 2000 15:42:50 +0100
Message-ID: <387C92EA.128572FB@sit.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US