Note
OceanBase Database does not support this view at present.
Overview
ALL_METHOD_PARAMS describes the method parameters of the object types accessible to the current user.
Related views
DBA_METHOD_PARAMS
USER_METHOD_PARAMS
Field description
Field name |
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. |