Hello. I have the following problem: I need to create a procedure that inserts data into tablr after form submit in APEX (Application Express). I just need to know how can I get the ID of user in application who has logged in. For example I have table named Worker and there are fields: 1) worker_id 2) username 3)password. My question is: I have logged in as one of workers, how can I pass this worker's worker_id to trigger which calls procedure and passes worker_id to procedure after form submit in Oracle APEX????
Thank you very much for your answer. In fact I was aware of that app_user thing before, but I found out that my mistake was actually the fact that I didnt know
how to use it in procedures. Anyway, I managed to solve my problem and I'm glad :) Cheers!