Unable To Save File Using UTL_FILE In Asm Directory Ora-29283 (Doc ID 333908.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Mar-2013***


Symptoms

Trying to access file located in ASM directory using  UTL_FILE like

f_file := UTL_FILE.FOPEN('ASMDIR','gmlfo1.txt','W');


where ASMDIR is an Automatic Storage Manager directory fails during runtime with

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms