Re: delete file from PL/SQL

From: Christopher Beck <christopher.beck_at_oracle.com>
Date: Thu, 16 May 2002 16:45:13 -0400
Message-ID: <QSUE8.16$yH2.77@news.oracle.com>

FYI: In 9i rel2 you can using UTL_FILE.FREMOVE()

chris.

--
Christopher Beck, Principal Technologist, Oracle Corporation,
christopher.beck_at_oracle.com
Beginning Oracle Programming,
http://www.amazon.com/exec/obidos/ASIN/186100690X



"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3CE3DEFF.336E2CA1_at_exesolutions.com...


> famuz wrote:

>

> > Hello,

> >

> > I have a fairly simple problem, or at least that's what I thought

initially.


> > I'm running Oracle 8.1.6 on Windows NT. I'm reading an ASCII

> > file from the UTL_DIR and when I'm done reading, I would like to

> > delete the file. The only way I've found to work so far is to use the

> > dbms_backup_restore.deletefile procedure. The drawback is that

> > the full file path is needed. The file itself always has the same file

name.


> >

> > I've been using Google Groups to search newsgroups for answers

> > and/or examples, to no avail. I've seen things such as pipes and

> > external procedures mentioned, but I still don't know how any of

> > these can be of use.

> >

> > What would be the best way to solve this problem?

> >

> > Greetings,

> >

> > Toine Beijers

>

> SQLJ (Java). There is no way to do this within UTL_FILE or PL/SQL.

>

> Daniel Morgan

>

Received on Thu May 16 2002 - 15:45:13 CDT