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

[Former Member]

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]

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

[Former Member]

There are exception : Table Load Failure

and Others.

[Peranandam]

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]

What if mail sending fails??

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

[Peranandam]

Hi,

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

or

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

Regards,

Peranandam