UTL_FILE inalid directory path

[djramesh04]

ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FI LE", line 33
ORA-06512: at "SYS.UTL_FI LE", line 436
ORA-06512: at "CPLNMGR.PARSE_ STRING", line 13
ORA-06512: at line 1

CREATE OR REPLACE DIRECTORY mydir AS 'C:\CPALN\TEST\ ';
create or replace procedure parse_string
is

output_file utl_file.file_t ype;
begin
output_file := utl_file.fopen ('MYDIR','sampl e_file.csv', 'A');

utl_file.put_li ne (output_file, 'welcome to idia');
-- utl_file.put_li ne (output_file,( 'welome','to',' india'));
utl_file.fclose (output_file);
end;

[amitpatel66]

ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FI LE", line 33
ORA-06512: at "SYS.UTL_FI LE", line 436
ORA-06512: at "CPLNMGR.PARSE_ STRING", line 13
ORA-06512: at line 1

CREATE OR REPLACE DIRECTORY mydir AS 'C:\CPALN\TEST\ ';
create or replace procedure parse_string
is

output_file utl_file.file_t ype;
begin
output_file := utl_file.fopen ('MYDIR','sampl e_file.csv', 'A');

utl_file.put_li ne (output_file, 'welcome to idia');
-- utl_file.put_li ne (output_file,( 'welome','to',' india'));
utl_file.fclose (output_file);
end;

You can access only those directoried that listed out by the following query:

select value from v$parameter where name = 'utl_file_dir'
 

If you want to create new direcotry as done above, then ask your DBA to add the directory in the init.ora parameter file.
then you also need to GRANT read,write on that direcotyr to particular user from where you need to access that directory.