Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete a flat file in SQL
With straight pl/sql it isn't possible, though you could open it for writing
(not appending) and then close it - no more data, but still a file there.
"TP" <TP_at_infinity.com> wrote in message
news:3C4EFA80.6000402_at_infinity.com...
> Hi smart people,
>
> I read data from a flat file in say c:\tmp and put it in oraclae 8.1.7
> using a procedure and UTL_FILE stuff. Now I want to delete this file
> just using PL/SQL (no c/ java/ c++/ vb etc). How can I do it? Is it even
> possible?
>
> thanks a lot
>
> Tom
>
Received on Wed Jan 23 2002 - 12:08:57 CST