Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE
> 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...Received on Fri Oct 26 2001 - 13:09:53 CDT
> 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
>
>
![]() |
![]() |