topic Re: how to put commit in user exit in Application Development and Automation Discussions

how to put commit in user exit

Former Member — Tue, 05 Sep 2006 19:04:07 GMT

Hi!

I waana know that is it possible to out commit after coding user exit.. and if it is can anybody tell me how to do that..

Re: how to put commit in user exit

suresh_datti — Tue, 05 Sep 2006 19:13:00 GMT

It is not advisable to use the COMMIT WORK statement inside a User exit as it can lead to errors and/or inconsistencies.

~Suresh

Re: how to put commit in user exit

Former Member — Tue, 05 Sep 2006 19:14:50 GMT

We had a case where one of the developer put a Commit in the user exit and it created big problems. We created a OSS note only to realize that it was our mistake, lesson learned was never to put a commit in the user exit.

hith

Sunil Achyut

Re: how to put commit in user exit

Former Member — Tue, 05 Sep 2006 19:21:39 GMT

You should not do that.

After the user exits code is triggered, the transaction's own commits statements will commit the database anyway.

Regards,

Ravi

Re: how to put commit in user exit

Former Member — Tue, 05 Sep 2006 19:50:21 GMT

instead of using commit...

create a Z function module and put your logic into that

and call that function module with 'in update task' addition.

then your function module will be called when the transaction is commited or rollbacked if your transaction is cancelled without saving... it is the best way in your case.