Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE.FCOPY ORA-29284

mcardiaApr 26 2012 — edited Apr 30 2012
Hi!

In the server I have two files

a.xml with 9k
b.xml with 100k

They have exactly the same permissions (664) and same owner/group.
The files are not corrupted.

I´m trying to copy these files. It works for a.xml, but do not for b.xml.

There is a size limit for fcopy? or what could be wrong?
begin
    utl_file.fcopy('BFILE_DIR', 'a.xml', 'BFILE_DIR', 'tmp_a.xml');
    utl_file.fremove('BFILE_DIR', 'tmp_a.xml');
end;
returns:
PL/SQL procedure successfully completed.
and
begin
    utl_file.fcopy('BFILE_DIR', 'b.xml', 'BFILE_DIR', 'tmp_b.xml');
    utl_file.fremove('BFILE_DIR', 'tmp_b.xml');
end;
returns:
ERROR at line 1:
ORA-29284: file read error
ORA-06512: at "SYS.UTL_FILE", line 262
ORA-06512: at "SYS.UTL_FILE", line 1139
ORA-06512: at line 2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2012
Added on Apr 26 2012
5 comments
2,706 views