Note
OceanBase Database does not support this view at present.
Purpose
The ALL_METHOD_PARAMS view displays the method parameters of the object types accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_METHOD_PARAMS
USER_METHOD_PARAMS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(30) | NO | The owner of the type. |
| TYPE_NAME | VARCHAR2(30) | NO | The name of the type. |
| METHOD_NAME | VARCHAR2(30) | NO | The name of the method. |
| METHOD_NO | NUMBER | NO | The method number, which distinguishes this method from other overloaded methods with the same name. Do not confuse this number with the object ID. |
| PARAM_NAME | VARCHAR2(30) | NO | The name of the parameter. |
| PARAM_NO | NUMBER | NO | The number of the parameter, which is a positive number. |
| PARAM_MODE | VARCHAR2(6) | NO | The parameter mode. Valid values: |
| PARAM_TYPE_MOD | VARCHAR2(7) | NO | Indicates whether the parameter references other objects. |
| PARAM_TYPE_OWNER | VARCHAR2(30) | NO | The owner of the type of the parameter. |
| PARAM_TYPE_NAME | VARCHAR2(30) | NO | The name of the type of the parameter. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | The name of the character set. The default value is NULL. |