Note
OceanBase Database does not support this view.
Purpose
This view displays the parameters of a scheduler program in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | NO | The owner of the program to which the parameter belongs. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the program to which the parameter belongs. |
| ARGUMENT_NAME | VARCHAR2(30) | NO | The optional name of the parameter. |
| ARGUMENT_POSITION | NUMBER | NO | The position of the parameter in the parameter list. |
| ARGUMENT_TYPE | VARCHAR2(61) | NO | The data type of the parameter. |
| METADATA_ATTRIBUTE | VARCHAR2(19) | NO | The attribute of the metadata: |
| DEFAULT_VALUE | VARCHAR2(4000) | NO | The default value of the parameter, if the parameter is of the string type. |
| DEFAULT_ANYDATA_VALUE | VARCHAR2(128) | NO | The default value of the parameter, if the parameter is of the ANYDATA type. |
| OUT_ARGUMENT | VARCHAR2(5) | NO | Reserved. |
References
USER_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_PROGRAM_ARGS