Using UTL_FILE on Local Client Fails With INVALID_OPERATION EXCEPTION (Doc ID 337485.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 8.0.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Dec-2013***

Symptoms

Running a simple script to read a file on on local drive using the UTL_FILE PACKAGE.

It returns an EXCEPTION on the WHEN UTL_FILE.INVALID_OPERATION section of the EXCEPTION.

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