How to Copy Any File using UTL_FILE
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 10.1.0.2 and later
Information in this document applies to any platform.
To show you how to use the UTL_FILE package to copy any type of file:
- Text files
- Binary files
NOTE: While UTL_FILE.FCOPY can be used to copy valid text files, it does not copy binary files or invalid text files. An example of an invalid text file would be one that contains a character sequence that cannot be generated by the characters on your keyboard (i.e. the sequence of two CR's in a row on a Windows platform rather than CRLF, CRLF) and hence may be considered a binary file.
NOTE: As UTL_FILE first supported the reading and writing of binary files in 10gR1, this note can only be used with Oracle Database versions 10gR1 and later.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms