sent csv file in oracle forms [message #644660] |
Thu, 12 November 2015 02:40 |
|
chanafn
Messages: 1 Registered: November 2015
|
Junior Member |
|
|
[color=skyblue][b] file_name := 'doch.PDF';
ReportName:='doch';
from_file_name := all_paths.files_reports ||file_name;
rp2rro.setDesformat('PDF');
:parameter.rp2rroDesformat:='PDF';
rp2rro.setDestype('FILE');
:parameter.rp2rroDestype:='FILE';
rp2rro.setDesNAME(from_file_name);
:parameter.rp2rroDesname := from_file_name;
pl_id := get_parameter_list('pl_id');
IF NOT ID_NULL(pl_id) THEN
destroy_parameter_list(pl_id);
END IF;
pl_id := create_parameter_list('pl_id');
rp2rro.rp2rro_run_product(reports,ReportName, SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,'');
to_file_name := all_paths.dir_send_files || file_name;
from_file_name := all_paths.files_reports ||file_name;
my_cmd := 'copy/y '||from_file_name || ' ' || to_file_name;
host(my_cmd, NO_SCREEN);
mail_attach('c@gmail.com', TO_CURS_1.MAIL, subj_txt, msg_txt, file_name);
how i suit this code to xls file
this code work perfect with pdf
[Updated on: Thu, 12 November 2015 02:42] Report message to a moderator
|
|
|
|