Use UTL_FILE.FCLOSE to close a file : UTL_FILE « System Packages « Oracle PL / SQL






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

1.Writing "Hello World!" to a File
2.Use UTL_FILE.PUT_LINE to write a line of text to a file
3.Use utl_file.fopen to open a file
4.Use UTL_FILE to read from a file and insert into the lecturer table.
5.Use UTL_FILE to print a transacript to a file.
6.Catch different UTL_FILE related errors
7.Save data in a cursor to a file
8.Load the data into table myTable. You may use any valid number for column c1's data.