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

Cris Carampa wrote:

> 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,
>

Or dump the entire file into a CLOB field using the DBMS_LOB package.

Daniel Morgan

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)