Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Send file to other filesystem using PLSQL

Re: Send file to other filesystem using PLSQL

From: Jack <none_at_noe.com>
Date: Tue, 09 Nov 2004 12:32:50 GMT
Message-ID: <SN2kd.197$124.132@read3.inet.fi>


See that:
You can setup a "Directory" to point towards a network share.

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1099969572.93305_at_yasure...
> 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)
Received on Tue Nov 09 2004 - 06:32:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US