UTL_FILE.FCOPY Produces An Empty File After Upgrade

(Doc ID 1329769.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version: and later   [Release: 10.2 and later ]
HP-UX Itanium


Executing UTL_FILE.FCOPY on HP-UX Itanium, Oracle is
producing an empty (0 byte) file to the destination directory.
In SQL*Plus problem can be reproduced using:

connect / as sysdba

!echo 'test content for file copy' > /tmp/test_in

drop directory test;
create directory test as '/tmp';

drop user tc cascade;
create user tc identified by tc;
grant connect,resource,create any directory to tc;

connect tc/tc

!cat /tmp/test_in
exec utl_file.fcopy('TEST','test_in','TEST','test_out');
!cat /tmp/test_out


Patch applied


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms