UTL_FILE包

设置utl_file_dir参数

SQL> alter system set utl_file_dir='/u01/app/oracle' scope=spfile;

System altered.

SQL> startup force;                 

SQL> show parameter utl_file

NAME                                 TYPE       VALUE

-------------------------------- ----------- ------------------------------

utl_file_dir                         string      /u01/app/oracle

 

设置多个路径：

SQL> alter system set utl_file_dir='/u01/app/oracle', '/oradata' scope=spfile;

System altered.

SQL> startup force

NAME                                 TYPE      VALUE

-------------------------------- ----------- ------------------------------

utl_file_dir                         string      /u01/app/oracle, /oradata

 utl_file的IO操作

SQL> declare

  fn utl_file.file_type;

begin

  fn := utl_file.fopen('/u01/app/oracle', 'utl_test.txt', 'W');

  utl_file.fclose(fn);

end;

/

PL/SQL procedure successfully completed.