output file - liamlamth/blog GitHub Wiki

declare
    lf_file_total                   UTL_FILE.FILE_TYPE;
begin
    lf_file_total := utl_file.fopen( 'UTL_DIR', to_char( 'file_name.log', 'a', 32767 );
        utl_file.put_line(lf_file_total,'some text body');
    utl_file.fflush(lf_file_office);
    utl_file.fclose(lf_file_office);
end;