Note
OceanBase Database does not support this view. The query result of this view is always empty.
Purpose
This view displays the parameters of the current tenant's scheduler program.
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 | If the parameter is of the string type, the default value of the parameter. |
| DEFAULT_ANYDATA_VALUE | VARCHAR2(128) | NO | If the parameter is of the ANYDATA type, the default value of the parameter. |
| OUT_ARGUMENT | VARCHAR2(5) | NO | Reserved. |
References
USER_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_PROGRAM_ARGS
