Writing "Hello World!" to a File : UTL_FILE « System Packages « Oracle PL / SQL






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

Writing "Hello World!" to a File

  
CREATE OR REPLACE PROCEDURE HELLOFLE IS
      v_MyFileHandle UTL_FILE.FILE_TYPE;
 BEGIN
      v_MyFileHandle := UTL_FILE.FOPEN('C:\','HELLO.TXT','a');
      UTL_FILE.PUT_LINE(v_MyFileHandle,'Hello World! ' || 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.Use UTL_FILE.PUT_LINE to write a line of text 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.