topic Re: Inputs needed : Logic implementation on sending mail and database update. in Application Development and Automation Discussions

Inputs needed : Logic implementation on sending mail and database update.

Former Member — Wed, 01 Apr 2009 04:12:44 GMT

Hi All,

I have a requirement in which I need to send a mail and then update a database table.

Sending mail and table update should work as one transaction i.e should be consistent.

I need your inputs to implement the above.As per my understanding :

CASE I : Send mail and then update database.

ISSUE : If database table is not updated, a 'ROLLBACK WORK' is called but mail cannot be reterived.

CASE 2 :Update database and then send mail.

ISSUE : IF database update is successful but mail sending failed??

Thanks in advance.

former_member156446 — Wed, 01 Apr 2009 04:16:53 GMT

why do you think database will not update? update or insert statement should help u

Former Member — Wed, 01 Apr 2009 04:18:12 GMT

There are exception : Table Load Failure

and Others.

Peranandam — Wed, 01 Apr 2009 04:19:54 GMT

Hi its very simple.

you have to regist your subroutine with on commit addition .

for your case1.

perform send_mail on commit.

perform update_table.

*--here you have to evaluvate sy-subrc of database update .

if sy-subrc = 0.

*here you are sending mail if update has beeen sucess or trigger error what every you need.

commit work.

endif.

Regards,

Peranandam

Former Member — Wed, 01 Apr 2009 04:45:08 GMT

What if mail sending fails??

Database is updated and mail sending fails, This is also not desired.

Peranandam — Wed, 01 Apr 2009 13:46:55 GMT

Hi,

in my point of view if you coded properly for sending mail by considering all the failiure factor then there is no problem.

If mail sending fails, revert back all the changes you have updated in the table and display error log.

Regards,

Peranandam