Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE
The closest thing is to open the file in Write mode, this is suppose to
'recreate' the file and in effect empty it.
Have you tried this and found that it doesn't empty it?
"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 Thu Oct 25 2001 - 18:50:36 CDT