APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger work around for getting APP_USER in updated_by column

user-z52q7Apr 26 2023

Hi,

I have a table “TEAM" and I would like to populate the “updated_by” column with the APP_USER when some edits a table row.

For “created_by” it worked just fine static with &APP_USER.

But for “updated_by" i am still struggeling.

I tried to implement several trigger versions but had no success.

Is there eventually a work around with processing or dynamic action?

Currently i am using APEX version 20.2.0.

Thank you in advance!

Added on Apr 26 2023

4 comments

913 views