Accessing a user email address from the database
422861Nov 2 2006 — edited Nov 3 2006Hi,
I really need help with the following.
I am adding functionality where users can set reminders that will then be sent to them by email when the reminder is due. I am going to utilise dbms_job to do this. My problem is that I am using apex authentication and users for the rest of the application and I need to retrieve the email address from apex. I cannot use wwv_flow_users as the email will be sent from a job in the database therefore there will be no current logged in user / workspace / session.
There must be some way of accessing an internal apex table / view or something that can tell me what the email addresses of my users are without being signed into an apex session.
Please help, this is quite urgent.
Thank you in advance.
Lee