Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER - Question about calling programs from chain steps

edited Jun 23, 2009 10:49PM in Database Administration (MOSC) 3 commentsAnswered
 I'm new to using the DBMS_SCHEDULER so I'm unaware if this is actually possible.  I want to call a program (which references a procedure) from a chain step with an argument, but it's not clear if I can specify an argument within the chain step.  Here's an example of what I'm trying to accomplish:
BEGIN

    
    dbms_scheduler.create_program(
    program_name => 'TEST_PROG',
    program_action => 'A_PACKAGE.DUMMY',
    program_type => 'STORED_PROCEDURE',
    number_of_arguments => 1,
    enabled => FALSE);
   
   DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (
   program_name            => 'TEST_PROG',
   argument_position       => 1,
   argument_name           => 'ARG1',
   argument_type           => 'VARCHAR2',
   default_value           => 'X');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center