Re: Manipulate files or run external process

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 15 Oct 2002 15:30:43 GMT
Message-ID: <3DAC349C.9B6BDFDD@exesolutions.com>

Thierry Le Blond wrote:

> I need to find and read files from a stored procedure.
> So I have two solutions :
> - Reading the file directly using functions from a package able to manage
> files, and my question is "which package can do that ? and what are the
> constraints ?"
> - Activating an external process that can read files (written in C for
> example), and then my question is "how to launch or activate an new process
> from my stored procedure".
>
> Thanks in advance.
> Thierry Le Blond.

Does your Oracle have a version and edition (like 8.1.7.4 Enterprise Edition)?

Look at UTL_FILE if 8i and UTL_FILE and EXTERNAL TABLES if 9i.

Daniel Morgan Received on Tue Oct 15 2002 - 10:30:43 CDT