OraFAQ Forum: Forms » Change Email Subject

Home » Developer & Programmer » Forms » Change Email Subject

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

Change Email Subject [message #649466]

Sun, 27 March 2016 10:01

kuwait
Messages: 55
Registered: October 2007

Member

Hi,

I want to change the subject of an email generated report using forms 6i and oracle 9i

I used the following code

ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'Attached Report');

but it won't change it remains as the default subject "Report sent from Report Builder"

how to do it?

Following is part of the code
------------------------------

declare
pl_id paramlist;

	begin
		 pl_id := get_parameter_list('tdata');
		 if not id_null(pl_id) then
		    destroy_parameter_list(pl_id);
		 end if;
		 
		
		 pl_id := create_parameter_list('tdata');
		 add_parameter(pl_id,'PARAMFORM',text_parameter,'No');
		 ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'Attached Report');
		 add_parameter(pl_id,'DESTYPE',text_parameter,'Mail');
		 Add_Parameter(pl_id,'DESFORMAT',TEXT_PARAMETER,'PDF');
		 Add_Parameter(pl_id,'REPORT_DESFORMAT',TEXT_PARAMETER,'PDF');
		 Add_Parameter(pl_id,'DESNAME',TEXT_PARAMETER,'xxx@mail.com');
		 Run_Product(REPORTS, 'rep', ASYNCHRONOUS, RUNTIME,FILESYSTEM,pl_id, NULL);

        exception
	  when others then
	  message('Error call 87036');
        end;

[Updated on: Sun, 27 March 2016 10:02]

Report message to a moderator

Re: Change Email Subject [message #649467 is a reply to message #649466]

Sun, 27 March 2016 11:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure it'll help, but you can try it anyway: what happens if you shorten the subject to a single word (just for testing purposes), such as

ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, 'AttachedReport');

If it turns out to work correctly, try to use two words, but now enclose them into double quotes, such as

ADD_PARAMETER(pl_id, 'SUBJECT',TEXT_PARAMETER, '"Attached Report"');

Any improvement?

[Updated on: Sun, 27 March 2016 11:14]

Report message to a moderator

Re: Change Email Subject [message #649468 is a reply to message #649467]

Sun, 27 March 2016 11:19

kuwait
Messages: 55
Registered: October 2007

Member

Hi,

Unfortunately, I tried those before, It's the same didn't take it.

Thanks for trying to help

Report message to a moderator

Re: Change Email Subject [message #649499 is a reply to message #649468]

Tue, 29 March 2016 03:21

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

If the other parameters are working then I would assume the problem lies with the report not the form.

Report message to a moderator

Previous Topic:	How to display the environment name on login screen
Next Topic:	SET BLOCK STATUS in Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 04:43:30 CST 2025