UTL_FILE example

The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files.

Example:

declare
l_output utl_file.file_type;
begin
l_output := utl_file.fopen('DUMP_DIR','output.txt','w');
utl_file.put(l_output,'utl_file example');
utl_file.fclose(l_output);
end;