Re: problem of sys.utl_file.fopen

Hi,
Prior to oracle 9i, we need to have that 'C:\temp' in utl_file_dir parameter. Hence please verify if your utl_file_dir has this value set. You can check in this way in SQL*Plus command prompt.

---> show parameter utl_file

>From oracle 9i, you need not have the directory where you store the
files as 'utl_file_dir' parameter. You can associate this to Oracle object DIRECTORY. Hence if you dont have it as 'utl_file_dir' you can check if the directory is created for you and whether that directory has this 'C:\temp' associated with it.
You can check as follows:
select * from all_directories where directory_path = 'Your directory path goes here'

If both are fine, i suspect whether the Oracle user which creates/reads the files has access to that folder C:\temp.

Regards,
Giridhar Received on Thu Dec 29 2005 - 09:48:54 CST