Re: UTL_FILE.INVALID_OPERATION (trying to open file)

sfelten_at_ipsos-asi.com wrote:
>
> When using the UTL_File package to Open a file I get the following Exception
> error.
>
> UTL_FILE.INVALID_OPERATION - Due to lack of permissions for access to the
> file. Contact dba for access rights.
>
UTL_FILE allows access only to directories which are listed in the startup-script (e.g. init.ora).

The correct entry type is UTL_FILE_DIR. Normally your DBA has to maintain this script.

Hope, that helped.

-- 
Markus Krämer
Cathbad_at_t-online.de