Home » Developer & Programmer » Forms » sent csv file in oracle forms
sent csv file in oracle forms [message #644660] Thu, 12 November 2015 02:40 Go to next message
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

Re: sent csv file in oracle forms [message #644669 is a reply to message #644660] Thu, 12 November 2015 15:51 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
What is your Forms/Reports version?
Previous Topic: forms not running
Next Topic: Calculated Field is not working properly
Goto Forum:
  


Current Time: Tue Oct 27 02:19:40 CDT 2020