2 Replies Latest reply: Dec 22, 2012 3:03 AM by 981322 RSS

    User ID

    981322
      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 for your answers
        • 1. Re: User ID
          Matthew Morris
          The username of the account logged into application express can be accessed via APP_USER. In PL/SQL procedures, you'd access with: v('APP_USER') or
          :APP_USER.
          • 2. Re: User ID
            981322
            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!