Unicode TextFile Read Write - bami74/me GitHub Wiki

  • Ascii Text Read
v_filename       varchar2(100);

file_handle      := sys.utl_file.fopen('DIR', v_filename, 'r');
sys.utl_file.get_line(file_handle, v_line);

if sys.utl_file.is_open(file_handle) then
  sys.utl_file.fclose(file_handle);
end if;
  • Unicode Text Read
v_filename       varchar2(100);

file_handle      := sys.utl_file.fopen_nchar('DIR', v_filename, 'r');
sys.utl_file.get_line_nchar(file_handle, v_line);

if sys.utl_file.is_open(file_handle) then
  sys.utl_file.fclose(file_handle);
end if;