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

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE

Re: UTL_FILE

From: Syltrem <syltrem_at_videotron.spammenot.ca>
Date: Fri, 26 Oct 2001 14:09:53 -0400
Message-ID: <KAhC7.483$qb4.1850@tor-nn1.netcom.ca>


> Return a boolean if your function was successful.

That probably is what Micro$oft does. That`s why it spits out messages like "can't open file" and does not say why.

Make your subroutine return a condition value "file is locked", "file does not exist", "insufficient privileges to open file", etc.

I hope someone at M$ will read this too.

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"bhogak" <bhogak_at_yahoo.com> a écrit dans le message news:
9rakpm$q5i$1_at_bob.news.rcn.net...

> UTL_FILE does not have procedures to empty, rename, delete, move, change
> permissions etc on a file. It allows basic read and write features.
> However, you can write your own function to empty the file - Pass the
> directory and file name to this function. Let it open it in 'W' mode and
> immediately close it.
> Return a boolean if your function was successful.
> hth
> bhogak
>
> Shibu Mathew <shibumathew_at_alliantfs.com> wrote in message
> news:3004f220.0110251124.784a513c_at_posting.google.com...
> > Hello
> >
> > I used UTL_FILE to write into an Operating System File(HP Unix). Now,
> > does UTL_FILE have a function/procedure to empty the file created,
> > before writing to the file again. I know that UTL_FILE.PUT_LINE will
> > overwirte the file, but to make sure that the file created is new, I
> > want to empty the existing file before writing into it again.
> > I would really appreciate any answers to the above question.
> > Thank You
> >
> > Shibu Mathews
>
>
Received on Fri Oct 26 2001 - 13:09:53 CDT

Original text of this message

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