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 topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_METHOD_PARAMSUSER_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 | Indicates whether the character set of the method is a fixed-length character set (CHAR_CS), a fixed-length natural character set (NCHAR_CS), or a particular character set specified by the user. |