DROP_PROGRAM_ARGUMENT v17

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 the 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's being modified.

argument_position

argument_position specifies the position of the argument that's being dropped.

argument_name

argument_name specifies the name of the argument that's 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');