Use UTL_FILE.PUT_LINE to write a line of text to a file : UTL_FILE « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. UTL_FILE

Use UTL_FILE.PUT_LINE to write a line of text to a file

  

CREATE OR REPLACE PROCEDURE SHAREFLE IS
  v_MyFileHandle UTL_FILE.FILE_TYPE;
  BEGIN
       v_MyFileHandle := UTL_FILE.FOPEN('C:\','HELLO.TXT','a');
       UTL_FILE.PUT_LINE(v_MyFileHandle, 'Hello Again for the Second Time! ' || TO_CHAR(SYSDATE,'MM-DD-YY HH:MI:SS AM'));
       UTL_FILE.FCLOSE(v_MyFileHandle);
 EXCEPTION
      WHEN OTHERS THEN
           DBMS_OUTPUT.PUT_LINE
                ('ERROR ' || TO_CHAR(SQLCODE) || SQLERRM);
           NULL; 
 END;








Related examples in the same category

1.Writing "Hello World!" to a File
2.Use utl_file.fopen to open a file
3.Use UTL_FILE.FCLOSE to close 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.