Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Automated text file import
Randy Harris wrote:
> 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.
>
> --
> Randy Harris
> (tech at promail dot com)
If you have JServer installed in the database, then this can be simply accomplished by using Java stored procedures. java.io.* and java.sql.* APIs have all the functions that you need to do this.
For information, look at java docs and http://tahiti.oracle.com on how to create a java stored procedure and call it from PLSQL.
Regards
/Rauf
Received on Mon Mar 28 2005 - 07:09:08 CST