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 -> Re: Automated text file import

Re: Automated text file import

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Mar 2005 05:09:08 -0800
Message-ID: <1112015348.124297.237510@o13g2000cwo.googlegroups.com>

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

Original text of this message

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