附件下载功能
使用 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(https://blog.csdn.net/%3C/span%3E%3C/span%3E%C2%A0%3Cspan%20style=%22font-family:Courier%20New;%20font-size:12px;%20color:#008080%22%3E%3Cspan%20style=%22font-size:10pt%22%3Eurl%3C/span%3E%3C/span%3E%3Cspan%20style=%22font-family:Courier%20New;%20font-size:12px;%20color:#000080%22%3E%3Cspan%20style=%22font-size:10pt%22%3E);
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(https://blog.csdn.net/%3C/span%3E%3C/span%3E%C2%A0%3Cspan%20style=%22font-family:Courier%20New;%20font-size:12px;%20color:#008080%22%3E%3Cspan%20style=%22font-size:10pt%22%3Eurl%3C/span%3E%3C/span%3E%3Cspan%20style=%22font-family:Courier%20New;%20font-size:12px;%20color:#000080%22%3E%3Cspan%20style=%22font-size:10pt%22%3E);
END;
本文介绍了如何使用Oracle EBS系统中的fnd_lobs表和fnd_gfm包来实现附件的下载功能。通过获取fnd_lobs表中的文件ID构建下载URL,可以直接下载存储的文件。同时,展示了如何将自定义内容写入fnd_lobs表并在浏览器中显示。
1万+

被折叠的 条评论
为什么被折叠?



