| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How Can I write basic SQL Loader
Beatrice Juniel wrote:
>
> 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
Check the UTL_FILE procedure. It allows you read/write from flat files.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Jan 12 2000 - 04:35:14 CST
 |
 |