Re: Reading a file on Windows from a trigger in an Oracle database

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 1 Oct 2003 07:47:21 -0700
Message-ID: <3722db.0310010647.45c2eb5@posting.google.com>

Or you could upgrade to 9i and define an "external table" for the flat file, and read the data as if it was a normal Oracle table.

Daniel

> h wrote:
>
> > I need to read a file stored on a Windows machine whenever a record is
> > inserted into a table. Then insert this file into another table in a
> > CLOB/BLOB column.
> >
> > My oracle version 8.1.7.4 and it is running on Unix.
>
> Just a couple of ideas: you can mount the Windows directory on the Unix
> machine using NFS or SAMBA and then read the file with the UTL_FILE
> package or you can configure an HTTP server on the Windows machine and
> read the file using the UTL_HTTP package.
>
> Kind regards,
Received on Wed Oct 01 2003 - 09:47:21 CDT