OraFAQ Forum: Forms » sent csv file in oracle forms

Home » Developer & Programmer » Forms » sent csv file in oracle forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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