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

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,

-- 
Cris Carampa (spamto:cris119_at_operamail.com)