Thanks for the suggestion. But the main problem is that the file needs
to be read from a trigger. So i think the external table option is of
limited use here.
Daniel Roy wrote:
> 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 Thu Oct 02 2003 - 04:37:28 CDT
