Oracle EBS附件下载功能

 附件下载功能
使用 fnd_lobs 表结合 fnd_gfm 包下载文件，可以下载已经存在fnd_lobs表里的文件，也可以手动写些内容进fnd_lobs表，然后在浏览器里显示：
--1.下载fnd_lobs表里已经存在的文件： DECLARE   v_file_id NUMBER;   url       VARCHAR2(500 ); BEGIN   --Get the file_id of the file which you want to download in fnd_lobs   v_file_id := xxxxxx;   --Get The Download URL   url := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,                                         v_file_id,                                         TRUE);   fnd_utilities.open_url( url); END; --2.手动写内容进fnd_lobs表，并在浏览器中显示： DECLARE db_file NUMBER; mime_type VARCHAR2( 255) := ‘text/plain‘ ; out_string VARCHAR2( 32767) := ‘Just some plain text that is stored‘ ; web_server_prefix VARCHAR2( 500); url VARCHAR2 (500); BEGIN   db_file := fnd_gfm.file_create(content_type => mime_type,                                  program_name => ‘export‘);   fnd_gfm.file_write_line(db_file, out_string);   db_file := fnd_gfm.file_close(db_file);   url     := fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,                                             db_file,                                             TRUE);   fnd_utilities.open_url( url); END;