Oracle PL/SQL: UTL_FILE.FCOPY Example

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • PLSQL
  • 2 mins read

In Oracle PL/SQL, UTL_FILE.FCOPY procedure is used to copy a file. This article explains how to copy a file in PL/SQL using UTL_FILE.FCOPY procedure with syntax and examples.

Syntax

UTL_FILE.FCOPY (
src_location IN VARCHAR2,
src_filename IN VARCHAR2,
dest_location IN VARCHAR2,
dest_filename IN VARCHAR2,
start_line IN BINARY_INTEGER DEFAULT 1,
end_line IN BINARY_INTEGER DEFAULT NULL);

Parameter Details

src_locationLocation of the source file. (Directory Object Name)
src_filenameSource File Name.
dest_locationDestination for the copied file. (Directory Object Name)
dest_filenameDestination file name.
start_lineLine number at which to begin copying. The default is 1.
end_lineLine number at which to stop copying. The default is NULL.

UTL_FILE.FCOPY Examples

1. Example

The following example will copy the file emp.pdf in same directory MY_DOC with other name emp2.pdf.

BEGIN
UTL_FILE.FCOPY ('MY_DOC',
'emp.pdf',
'MY_DOC',
'emp2.pdf');
END;
/

2. Example

The following example will copy the file sqllog.log from one directory to another with just 3 lines only, starting from line number 1 to 3.

BEGIN
UTL_FILE.FCOPY ('MY_DOC',
'sqllog.log',
'MY_DOC2',
'sqllog.log',
1,
3);
END;
/

See also: