[PL/SQL]UTL_FILE記事

oracle plsql utl_file

Unicode的CSV檔編碼格式,要用NCHAR的Procedure

檔名跟路徑都是Case sensitive!!

 

BEGIN
   dst_file                   := UTL_FILE.fopen_nchar(LOCATION => v_workdir, filename => v_file_name, open_mode => 'R');
   UTL_FILE.get_line_nchar(FILE => dst_file, buffer => v_temp_str);
END;