DEFINE_PROGRAM_ARGUMENT v16
Use the DEFINE_PROGRAM_ARGUMENT
procedure to define a program argument. The DEFINE_PROGRAM_ARGUMENT
procedure comes in two forms. The first form defines an argument with a default value:
The second form defines an argument without a default value:
Parameters
program_name
program_name
is the name of the program to which the arguments belong.
argument_position
argument_position
specifies the position of the argument as it's passed to the program.
argument_name
argument_name
specifies the optional name of the argument. By default, argument_name
is NULL
.
argument_type IN VARCHAR2
argument_type
specifies the data type of the argument.
default_value
default_value
specifies the default value assigned to the argument. default_value
is overridden by a value specified by the job when the job executes.
out_argument IN BOOLEAN DEFAULT FALSE
out_argument
isn't currently used. If specified, the value must be FALSE
.
Example
This code fragment uses the DEFINE_PROGRAM_ARGUMENT
procedure to define the first and second arguments in a program named add_emp
:
The first argument is an INTEGER
value named dept_no
that has a default value of 20
. The second argument is a VARCHAR2
value named emp_name
and doesn't have a default value.
- On this page
- Parameters
- Example