Hi

If you like to access a file using UTL_FILE you should modify your init.ora file. The file should include the directories which are allowed to be accessed while using UTL_FILE.

That is if you like to create a file in 'D:' you should have an entry in your init.ora file as mentioned below.

UTL_FILE_DIR 'D:'

So Just add this and try again.

Regards

Maria Antony.

Hi Maria Antony

Thanks for the reply.

I tried by giving UTL_FILE_DIR 'D:' in the init.ora.71720061376 file.

but still it's having the same error.

please let me know the solution.

Thanks in advance.

Developer.

use these steps.

1 modify init.ora add a line

UTL_FILE_DIR 'D:My_DIR'

2. login as system as sysdba

shutdown immediate;

startup pfile <pfile path> like d:oracleadminorclpfileinit.ora

oracle should startup

create spfile from pfile;

if step 2 is not working then

alter sytem set utl_file_dir 'd:my_dir' scope spfile;

restart the system.

then try your programme.

create folder my_dir in d: drive( os level)

login system as sysdba

create direcotory my_dir as 'd:my_dir';

grant read write on directory my_dir to scott;