Note
OceanBase Database does not support this view. The query result is always empty.
Purpose
This view displays the information about parameters of programs that the current user can access.
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. Valid values: |
| DEFAULT_VALUE | VARCHAR2(4000) | NO | The default value of the parameter, if the parameter is of the string type. |
| DEFAULT_ANYDATA_VALUE | VARCHAR2(128) | YES | The default value of the parameter, if the parameter is of the ANYDATA type. |
| OUT_ARGUMENT | VARCHAR2(5) | YES | Reserved. |
References
USER_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_PROGRAM_ARGS