Master Note For PL/SQL UTL_FILE Package (Doc ID 1155024.1)

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

PL/SQL - Version 8.1.7.4 and later
Information in this document applies to any platform.
***Checked for relevance on 09-May-2014***

Purpose

This PL/SQL UTL_FILE master index note provides information on the relevant articles associated with the following topics:

Frequently Asked Questions

How To

Scope

The intended audience is for users of the PL/SQL API and built-in packages. The notes listed are for novice to experienced users.

Details

Frequently Asked Questions

Note.730774.1 FAQ and Known Issues While Using UTL_FILE.

How To

1)How to use UTL_FILE Package to Perform File I/O (UNIX) ?
Note 44307.1: Using the UTL_FILE Package to Perform File I/O (UNIX)

2)How To Set the Permission of the Files Created Using UTL_FILE?
Note.463312.1: How To Set the Permission of the Files Created Using UTL_FILE?
Note.74268.1 Using utl_file, how file permissions are determined, working sample

3)How To Save Table Data From an Oracle DB Into a User-Readable Text File ?
Note 443395.1: How To Save Table Data From an Oracle DB Into a User-Readable Text File (.txt Extension).

4)How to write CLOB data > 32K out to a file. ?
Note.358641.1:How to write CLOB data > 32K out to a file.

5)How To Write Out Multiple Clob Fields > 32k To A File in 4K chunks?
Note 358781.1: How To Write Out Multiple Clob Fields > 32k To A File in 4K chunks?

6)How To display the DBMS_OUTPUT From The Remote Procedure on Local Database ?
Note 453325.1: How To display the DBMS_OUTPUT From The Remote Procedure on Local Database.

7)How to use UTL_FILE to work on WINDOWS (Local drive and Network Share Drive) ?
Note 45172.1 : Running UTL_FILE on Windows NT

8) How to use UTL_FILE to work with different characterset ?
Note 227531.1 : Character set conversion when using UTL_FILE

9) How to add more then one utl_file_dir entry
Note.202159.1 How to specify multiple utl_file_dir entries when using a server side parameter file (spfile)

10) Uses of UTL_FILE
Note 352685.1 How To Output Text From Pl/Sql Procedure Via A Job

11)How to use UTL_FILE Package to Read, Write and Append to O/S Files
Note 119644.1 How to use UTL_FILE Package to Read, Write and Append to O/S Files