Re: utl_file.frename against utl_file.fcopy

Björn Wächter wrote:
> Hi all,
>
> I'm facing a strange problem. I'm executing these commands
> in my Oracle 10.2 Database running on debian linux.
>
>
> This one is working very well:
>
> utl_file.frename(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename,
> overwrite => TRUE
> );
>
>
> But when I execute this command with exactly the same
> filenames and directory names like in frename:
>
> utl_file.fcopy(
> src_location => v_source_dir,
> src_filename => p_s_filename,
> dest_location => v_destination_dir,
> dest_filename => p_s_filename
> );
>
> I'm getting an ORA-29284 file read error.
>
> As fare as I know linux. If a can move a file, there is no
> reason why copy should fail. The file is not existing in the
> destination location, so the overwrite => TRUE can not be the
> reason.
> Any ideas?
>
> Thanks Björn

Just a couple of thoughts.

ls -la and verify your permissions on the file.

Replace your variables with hard coded strings and see if the problem continues.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group