Re: utl_file question

From: Jonathan Lewis <>
Date: Wed, 20 Jun 2018 14:50:13 +0000
Message-ID: <MM1P123MB08424660742ED6C922E2E142A5770_at_MM1P123MB0842.GBRP123.PROD.OUTLOOK.COM>

I don't think that's right. It's desirable but not required.

In fact the 12.2 reference manual is the first place where Oracle says that utl_file_dir is deprecated, so a path name approach should work provided the paths are pre-declared in the utl_file_dir parameter.

Jonathan Lewis

From: <> on behalf of Hemant K Chitale <> Sent: 20 June 2018 15:13
Subject: Re: utl_file question

11g requires that each target directory to be accessed via a logical name created by the CREATE DIRECTORY command with GRANT READ, WRITE on the DIRECTORYs.

Received on Wed Jun 20 2018 - 16:50:13 CEST

Original text of this message