Oracle PL/SQL: UTL FILE file write to file example - Example of using UTL FILE to write to a flat (txt) file.

Quick Search:

Oracle PL/SQL: UTL_FILE file write to file example

Jump to:

Category: >> Oracle PL/SQL >> UTL_FILE file write to file example

<< last

next >>

Snippet Name: UTL_FILE file write to file example

Description: Example of using UTL_FILE to write to a flat (txt) file.

Also see:
» PACKAGES: initialization
» PACKAGES: related queries
» PACKAGES: alter package
» PACKAGES: overloading
» PACKAGES: one function
» PACKAGES: one procedure
» UTL_FILE
» Create Package
» UTL_FILE import data

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 11th, 2009

CREATE DIRECTORY test_dir AS 'c:\';
-- CREATE DIRECTORY test_dir AS '/tmp';
 
DECLARE
  fileHandler UTL_FILE.FILE_TYPE;
BEGIN
  fileHandler := UTL_FILE.FOPEN('test_dir', 'test_file.txt', 'W');
  UTL_FILE.PUTF(fileHandler, 'Writing TO a file\n');
  UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
  WHEN utl_file.invalid_path THEN
     raise_application_error(-20000, 'ERROR: Invalid PATH FOR file.');
END;
/