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

From: h <h_at_h.com>
Date: Thu, 02 Oct 2003 05:35:01 -0400
Message-ID: <ajSeb.5510$N94.3707@lakeread02>

Thanks to all of you for the valuable replies.

FYI, I am going to take the SAMBA route.

Paul Drake wrote:
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1065016052.654316_at_yasure>...
>

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

>
>
> XDB is another avenue in, via ftp, http or smb (9.2.0.4 patch
> recommended).
>
> Of course, I haven't actually used it yet, but on one of these (daily)
> train rides I intend to give it a whirl. not really the same when you
> run it on 127.0.0.1, but I don't feel like hauling 2 laptops :D
>
> Pd
Received on Thu Oct 02 2003 - 04:35:01 CDT