I am on 12c DB and APEX 5. I have a stored procedure that I need to invoke via DBMS_SCHEDULER job from my APEX page (the procedure cannot be run directly from APEX because of security privs needed). When the user hits submit from the APEX page, i need to execute the procedure below immediately, passing in the required items (see below). I granted 'APEX_ADMINISTRATOR_ROLE' to my parsing schema. What is the best way to do this?
create or replace procedure MAINT_APEX_BUILDER_USER
(l_user_type in varchar2,
l_user_name in varchar2,
l_first_name in varchar2,
l_last_name in varchar2,
l_web_password in varchar2,
l_email_address in varchar2,
l_action in varchar2)