DROP_PROGRAM_ARGUMENT v12
Use the DROP_PROGRAM_ARGUMENT
procedure to drop a program argument. The DROP_PROGRAM_ARGUMENT
procedure comes in two forms; the first form uses an argument position to specify which argument to drop:
DROP_PROGRAM_ARGUMENT( <program_name> IN VARCHAR2, <argument_position> IN PLS_INTEGER)
The second form takes the argument name:
DROP_PROGRAM_ARGUMENT( <program_name> IN VARCHAR2, <argument_name> IN VARCHAR2)
Parameters
program_name
program_name
specifies the name of the program that is being modified.
argument_position
argument_position
specifies the position of the argument that is being dropped.
argument_name
argument_name
specifies the name of the argument that is being dropped.
Examples
The following call to DROP_PROGRAM_ARGUMENT
drops the first argument in the update_emp
program:
DBMS_SCHEDULER.DROP_PROGRAM_ARGUMENT('update_emp', 1);
The following call to DROP_PROGRAM_ARGUMENT
drops an argument named emp_name
:
DBMS_SCHEDULER.DROP_PROGRAM_ARGUMENT(update_emp', 'emp_name');