UTL_FILE Page - 5

Page 5 of 5

Author: Saurabh Gupta Published on: 10th Aug 2011

UTL_FILE

FCOPY and FREMOVE

The screen dump below shows the file structure information of the directory UTLDIR.

Now, as per the requirement, I need to make a copy of Demo_file.txt in the same directory. The PL/SQL block below achieves the purpose.

Sample Code

DECLARE
LH UTL_FILE.FILE_TYPE
L_TXT VARCHAR2(1000)
BEGIN
UTL_FILE.FCOPY('UTLDIR','Demo_file.txt','UTLDIR','Demo_file_moved.txt')
EXCEPTION
WHEN NO_DATA_FOUND THEN
UTL_FILE.FCLOSE(LH)
END
PL/SQL procedure successfully completed.

Check the UTLDIR new file structure as below.

Similarly, FREMOVE is used to delete a file from a directory.

Sample Code

DECLARE
LH UTL_FILE.FILE_TYPE
L_TXT VARCHAR2(1000)
BEGIN
UTL_FILE.FREMOVE('UTLDIR','Demo_file_moved.txt')
EXCEPTION
WHEN NO_DATA_FOUND THEN
UTL_FILE.FCLOSE(LH)
END

Ads

Conclusion

In the tutorial, we saw the strength of the UTL_FILE operations. For static OS file management systems, UTL_FILE is one of the most frequent used utility in Oracle, where tasks like data loading and file operations can be easily carried out.

1 2 3 4 5

Read Next: Manage Oracle dependencies

This tutorial is part of a Oracle 11g Tutorial tutorial series. Read it from the beginning and learn yourself.

Oracle 11g Tutorial

Comments

Exforsys Connect

Exforsys e-Newsletter