Re: Calling SQL*Loader from a Procedure
Date: 25 Jun 2002 05:49:00 -0700
Message-ID: <db479d88.0206250449.4d803f6a_at_posting.google.com>
flyinghigh1962_at_yahoo.com (Clyde) wrote in message news:<bf477768.0206212303.6dbe8bb6_at_posting.google.com>...
> I'm creating an application(9i on W2000) where the user will need the
> ability to hit a button and load data from a .csv file in a given
> directory into the database. There would be a new file on a daily
> basis the user would need to load. My original assumption was to use
> SQL*Loader to move the data, but I'm having difficulty finding
> examples of how it can be called from a procedure. I'm familiar with
> SQL*Loader, and writing packages and procedures, but haven't had the
> need to put the two together until now. I'd rather not get into Pro*C
> if I can help it. Is there a simple way to call SQL*Loader from a
> procedure such as using DBMS_JOB, or some other Oracle supplied
> package? I believe all I would need to do would be to send a command,
> or a string, to the DOS prompt to kick off the SQL*Loader.
>
> If I can't do this, what are my other options to load this data? Each
> of these files will probably be about 6M-10M.
>
> All ideas, suggestions, and direction greatly appreciated!
>
> Clyde Reed
Have you considered using UTL_FILE? Might be ok if you're not talking about much data.
CE Received on Tue Jun 25 2002 - 14:49:00 CEST