Use UTL_FILE.FCLOSE to close a file
DECLARE
v_FileHandle UTL_FILE.FILE_TYPE;
BEGIN
v_FileHandle := UTL_FILE.FOPEN('/tmp/', 'utl_file.txt', 'w');
UTL_FILE.PUT_LINE(v_FileHandle, 'This is line 1!');
FOR v_Counter IN 2..11 LOOP
UTL_FILE.PUTF(v_FileHandle, 'This is line %s!\n', v_Counter);
END LOOP;
UTL_FILE.FCLOSE(v_FileHandle);
END;
/
--
Related examples in the same category