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: bhogak <bhogak_at_yahoo.com>
Date: Thu, 25 Oct 2001 22:23:05 -0500
Message-ID: <9rakpm$q5i$1@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 Thu Oct 25 2001 - 22:23:05 CDT

Original text of this message

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