Greetings,
I have a requirement, when a user logs in to my APEX application, I want to get the username and insert it into a table. I have written a simple PL/SQL block in the security attributes section in the shared components like this:
declare
l_user varchar2(200) := :APP_USER;
begin
Insert into people_table (username) values l_user;
end;
However, this is not inserting into my table. What am I doing wrong? Any help will be greatly appreciated.
Thanks
Vatsa