Re: utl_file question
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 20 Jun 2018 14:50:13 +0000
Message-ID: <MM1P123MB08424660742ED6C922E2E142A5770_at_MM1P123MB0842.GBRP123.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Hemant K Chitale <hemantkchitale_at_gmail.com> Sent: 20 June 2018 15:13
To: RStorey_at_dcso.nashville.org
Cc: ORACLE-L
Subject: Re: utl_file question
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.
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Hemant K Chitale <hemantkchitale_at_gmail.com> Sent: 20 June 2018 15:13
To: RStorey_at_dcso.nashville.org
Cc: ORACLE-L
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 20 2018 - 16:50:13 CEST