Re: List Files Created by UTL

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 2 Jun 2005 04:19:17 -0700
Message-ID: <1117711157.725640.268730@z14g2000cwz.googlegroups.com>

Neil wrote:
> Hi,
>
> Is there any way to list the files created by UTL_FILE in a directory
> created using the 'Create Directory' command using pl/sql?
>
> Thanks,
>
> Neil
>
> Version Info.
> Database : 10g Enterprise Edition Release 10.1.0.2.0 - Prod
> PL/SQL : Release 10.1.0.2.0 - Production
> O/S : Windows Server 2003

AFAIK... you cannot list files in a directory using any supplied PLSQL packages. This is where Java stored procedure can help you. Lookup usage for java.io in Java Docs.

Regards
/Rauf Received on Thu Jun 02 2005 - 06:19:17 CDT

Re: List Files Created by UTL_FILE