Shulou(Shulou.com)06/01 Report--

Use the fnd_gfm package to download standard attachments from the EBS system, download files in the fnd_lobs table, or write to files.

1. Download a file

Declare v_file_id NUMBER; url VARCHAR2; 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

two。 Write to a file

Declare db_file number; mime_type varchar2: = 'text/plain'; out_string varchar2 (32767): =' Just some plain text that is stored'; web_server_prefix varchar2; url varchar2; 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.