Save string to a file with UTL_FILE.PUTF : File Write with UTL_FILE « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. File Write with UTL_FILE
SQL>
SQL> CREATE OR REPLACE PROCEDURE saveStringToFile(fid IN UTL_FILE.FILE_TYPE,it_is IN VARCHAR2)
  2  IS
  3  BEGIN
  4     UTL_FILE.PUTF (fid, 'string',it_is);
  5  END;
  6  /


SQL>
SQL>








31.35.File Write with UTL_FILE
31.35.1.Open the output file for writing
31.35.2.Save string to a file with UTL_FILE.PUTF
31.35.3.Save lines to a file
31.35.4.Write text to a file with UTL_FILE package