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: How to delete a flat file in SQL

Re: How to delete a flat file in SQL

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Wed, 23 Jan 2002 18:08:57 GMT
Message-ID: <Z_C38.8501$Xw4.1738876@news1.news.adelphia.net>


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

Original text of this message

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