RE: utl_file

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 28 Sep 2006 07:38:07 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF01A9A1@MSXVS04.trivadis.com>

Edwin

> what is maximum number of directories can be specified under
> utl_file_dir?
> is this unlimited? or say 100 or 200 files are son on?
> i have searched metalink but no where it is specified!

The limitation is the size: 512 bytes.

If you are in 9.2 or higher it is better to use DIRECTORY objects instead. With them you don't have this limitation and in addition you can correctly manage security.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 28 2006 - 00:38:07 CDT

RE: utl_file_dir