Re: Access Flat files on OS

From: Christopher Day <christopher.day_at_NOTexperian.com>
Date: Tue, 19 Jan 1999 22:04:14 -0000
Message-ID: <782vt8$2rm$1@news7.svr.pol.co.uk>

Barry,

If you want to check from PL/SQL you can use two methods depending on if your running V7 or V8 Oracle.

V7 - DBMS_PIPE
V8 - EXTPROC I would write a program outside of Oracle to poll the directory and use the various client connectivity methods to read and write to Oracle ie OO4O,Pro*C, ODBC,RDO,ADO etc.

Chris
Barry Ludwig wrote in message <36A467DD.B972759B_at_informore.com>...
>I am using utl_file to read files from directory on OS without any
>problems.
>
>Howevere I have to make a program that looks at a specific directory on
>the OS, and when any files exist i should read them
>into a Oracle Table.
>
>Are there any Packges, Functions etc that solve my problems
>
>1. I need to query a directory on OS.
>2. I need to erase the file after I have inserted it into a Table
>
>
>rgds
>
>
>
>--
>Barry Ludwig
>
>Informore BV - Phone : + 31 (0)35 6836560 - Fax : +31 (0)35 6834976
>
>
Received on Tue Jan 19 1999 - 16:04:14 CST