Sample code for UTL_FILE Out Bound

SQL Query: To know the path of UTL_FILE directory

                      SELECT  *
                      FROM     V$PARAMETER
                      WHERE  name  =  'utl_file_dir';


Code:

set serveroutput on;
/

DECLARE

l_file_rec  UTL_FILE.FILE_TYPE;

BEGIN

l_file_rec := UTL_FILE.FOPEN('utl_file_dir path'
                                                     ,'XXVE_FNDUSER_DATA.txt'
                                                     ,'W');

-- note, file name support .txt,.xls,.csv
                         
FOR i IN(SELECT user_id,user_name,last_update_date,last_updated_by
                 FROM    fnd_user
               WHERE rownum<100)
LOOP

UTL_FILE.PUT_LINE(l_file_rec,i.user_id||','||i.user_name||','||i.last_update_date||','||i.last_updated_by                                        );

END LOOP;
UTL_FILE.FCLOSE(l_file_rec);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Exception at Others Block'||','||SQLCODE||','||SQLERRM);
END;





Source: http://psoug.org/snippet/UTL_FILE-import-data_102.htm