DBMS_SCHEDULER - Question about calling programs from chain steps
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');
0