APEXtras

TYPE scheduler_arg_t is Record(
  argument_name VARCHAR2(100),
  argument_type VARCHAR2(100),
  default_value VARCHAR2(100),
  current_value VARCHAR2(4000)
  );
TYPE arglist_t is TABLE OF scheduler_arg_t INDEX BY PLS_INTEGER;
PROCEDURE ScheduleMyProcedure(p_P1  IN P1_TYPE,p_P2 IN P2_TYPE....,p_PN IN PN_TYPE) IS
    l_arglist arglist_t;
BEGIN
    l_arglist(1).argument_name := ‘p_P1';
    l_arglist(1).argument_type := ' P1_TYPE ';
    l_arglist(1).default_value := '';
    l_arglist(1).current_value := TO_CHAR(p_P1);
    l_arglist(2).argument_name := ‘p_P2';
    l_arglist(2).argument_type := ' P2_TYPE ';
    l_arglist(2).default_value := '';
    l_arglist(2).current_value := TO_CHAR(p_P2);
--Etc for every parameter p_P1...p_PN
  ScheduleSPJob(p_program_name       => 'MyProcedureName',
                p_argument_list      => l_arglist,
                p_schedule_date_time => NULL, -- Execute immediately
                p_force_recreate     => FALSE);
END;

Using the Oracle Scheduler in APEX