Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

File open and close with UTL_FILE package

SQL> SQL> DECLARE   2     lv_file_id_num  UTL_FILE.FILE_TYPE;   3  BEGIN   4     lv_file_id_num := UTL_FILE.FOPEN('c:\apps\loaders', 'test4.dat', 'W');   5     UTL_FILE.FCLOSE(lv_file_id_num);   6  END;   7  / SQL>