Re: List Files Created by UTL

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 02 Jun 2005 17:23:22 +0200
Message-ID: <d7n89b$fic$1@news.BelWue.DE>

DA Morgan wrote:
> 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

>
>
> In addition to the good advice provided by Rauf and Mark ... you can not
> create a direcotry with the CREATE DIRECTORY command in the way you seem
> to be assuming. CREATE DIRECTORY creates an abstraction in the data
> dictionary that points to an operating system directory. It never
> touches the O/S and doesn't care whether a physical directory exists.

And as a last addition:

There is of course no difference between files created with ut_file and any other (text)file that happens to reside in the same directory.

Just thought I'd mention that, too.

Cheers,

Holger Received on Thu Jun 02 2005 - 10:23:22 CDT

Re: List Files Created by UTL_FILE