Note
OceanBase Database does not support this view at present.
Purpose
The DBA_METHOD_PARAMS view displays the method parameters of the object types in the database.
Related views
ALL_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 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: IN, OUT, and IN OUT. |
| 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. |