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!

get correct App User in trigger

Gor_MahiaJul 14 2023 — edited Jul 14 2023

Hi,
iam using the below code in compound trigger within "BEFORE EACH ROW" block to capture the logged in user but somehow its recording the DB schema instead of the Apex application logged user.

  :NEW.CLOSED\_BY  :=  NVL(V('APP\_USER'), USER);  
     
   where am i going wrong here?

typical question i found here: https://forums.oracle.com/ords/apexds/post/how-to-pass-app-user-to-a-database-trigger-for-auditing-2402

   Using Apex 5.1x  
     
   regards,  
   Enock

This post has been answered by Gor_Mahia on Jul 14 2023

Jump to Answer

Added on Jul 14 2023

#oracle-apex, #plsql

1 comment

379 views