Re: Send file to other filesystem using PLSQL

KurtisK wrote:

> Yes, you can transfer a file from PL/SQL. I don't know why these guys in
> the Oracle newsgroup get so ornary. I think that Sybrand guy's attitude is
> wearing off on them.
>
>
> Use the UTL_FILE package. You can setup a "Directory" to point towards a
> network share.
>
> i.e.
>
> vcLocation := "SomeDirectoryName"
> fh := UTL_File.FOPEN(vcLocation, vcFileName, 'W', biMaxLineSize);
>
> etc ..
>
> etc ...

Because Sybrans knows of what he speaks and you are apparently unaware of the functionality of UTL_FILE.

UTL_FILE will gladly write a text file onto the local operating system. That has nothing to do with what the OP asked: Absolutely nothing!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)