Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Automated text file import
"Randy Harris" <randy_at_SpamFree.com> wrote in message news:<D8M1e.15299$DW.8123_at_newssvr17.news.prodigy.com>...
> I need to set up an automated import of text files into Oracle 8.1.7.4 on
> HP-UX, am looking for advice.
>
> Logic flow would look something like:
>
> On a periodic basis:
> Examine a directory for files (names not know in advance)
> Iterate through any found files:
> Import contents into a table
> Delete the file
>
> Can this be done from within Oracle, or does it need to be set up as a
> "push" from the OS? Any suggestions appreciated.
My suggest is to use java and load it into the DB and wrap it with PL/SQL. Then you can call the wrapper(s) as a normal package/procedure/function via SQL or PL/SQL. (If on a periodic basis: DBMS_JOB). Cheers.
Carlos. Received on Mon Mar 28 2005 - 09:58:42 CST