Indeed, you point the Directory to a Network Share as Jack mentioned. I am
well aware of how UTL_FILE works. Like I said, you guys are ornary and take
this too seriously. People participate to learn in these forums, not get
chastised with sarcasm.
Kurt
--
----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com
"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 - 10:40:36 CST
