Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using DBMS_SCHEDULER job to process request

bobmaganNov 2 2015 — edited Nov 11 2015

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)

This post has been answered by GregV on Nov 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2015
Added on Nov 2 2015
9 comments
2,851 views