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.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Jun 02 2005 - 09:58:45 CDT
