Re: PL/SQL file deletion / dir read

In article <93un0n$5o6$1_at_nnrp1.deja.com>,   chiappa_at_my-deja.com wrote:
> Read directory contents is very easy : just make DIR > cont.txt, using
> HOST, Java, or similar, and read the cont.txt file using UTL_FILE.
>
> Delete files : AFAIK you will need to send the OS DELETE command (or
> similar), again using HOST, Java, or similar.
>
> []s
> Chiappa
>
> In article <newscache$ci167g$8bn$1_at_news.freegates.be>,
> "Steven Brangers" <steven.brangers_at_altavista.net> wrote:
> > Is it possible to delete files from PL/SQL code
> > and
> > to read directory contents ( I mean: which files are available) from
 PL /SQL
> > ?
> >
> > Thanks,
> >
> > Steven Brangers -- dba/unix sysadmin.
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Your solution will work in sql*plus, it will not work in pl/sql as the host command is not available in pl/sql. He needs to write an external procedure calling the Windows API.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/