Note
OceanBase Database does not support this view at present. The query results of this view will always be empty.
Purpose
This view displays the arguments of scheduler programs accessible to the current user. The ALL_SCHEDULER_PROGRAM_ARGS view displays the arguments of scheduler programs accessible to the current user.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | NO | The owner of the program to which the argument belongs. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the program to which the argument belongs. |
| ARGUMENT_NAME | VARCHAR2(30) | NO | The optional name of the argument. |
| ARGUMENT_POSITION | NUMBER | NO | The position of the argument in the argument list. |
| ARGUMENT_TYPE | VARCHAR2(61) | NO | The data type of the argument. |
| METADATA_ATTRIBUTE | VARCHAR2(19) | NO | The metadata attribute. Valid values: |
| DEFAULT_VALUE | VARCHAR2(4000) | NO | The default value of the argument if the argument is a string. |
| DEFAULT_ANYDATA_VALUE | VARCHAR2(128) | YES | The default value of the argument if the argument is in AnyData format. |
| OUT_ARGUMENT | VARCHAR2(5) | YES | Reserved for future use. |
References
USER_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_PROGRAM_ARGS
