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

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 Wed Oct 01 2003 - 18:11:02 CDT