APEXtras

a development team dedicated to Oracle APEX

Oracle Scheduler Interface Calling Example

leave a comment »

PROCEDURE ScheduleResendEmail(p_email_id   IN NUMBER, p_recipients IN VARCHAR2) IS
    l_arglist arglist_t;
BEGIN
    l_arglist(1).argument_name := 'p_email_id';
    l_arglist(1).argument_type := 'NUMBER';
    l_arglist(1).default_value := '';
    l_arglist(1).current_value := TO_CHAR(p_email_id);
    l_arglist(2).argument_name := 'p_recipients';
    l_arglist(2).argument_type := 'VARCHAR2';
    l_arglist(2).default_value := '';
    l_arglist(2).current_value := p_recipients;
    ScheduleSPJob(p_program_name       => 'APEXTRAS_SCHEDULER.ResendEmail',
                  p_argument_list      => l_arglist,
                  p_schedule_date_time => NULL, -- Execute immediately
                  p_force_recreate     => FALSE);
  END;

Using the Oracle Scheduler in APEX

Written by Roger

14 May, 2009 at 3:57 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: