Re: How to delete a flat file in SQL

From: George Barbour <gbarbour_at_csc.com>
Date: Thu, 24 Jan 2002 08:59:03 -0000
Message-ID: <3c4fcc65@pull.gecm.com>

Daniel is of course right about using pure PL/SQL, but ... if your still keen.
Get a hold of Steve Feuerstein's book :- 'Guide to Oracle8i Features'. ISBN 1-56592-675-7.
There's a section titled 'Deleting Files from PL/SQL', it uses Java from PL/SQL, and it works fine.

George Barbour.

<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 Thu Jan 24 2002 - 02:59:03 CST