Note
Oracle mode of OceanBase Database does not support this view.
Purpose
This view displays the method parameters of the object type in the current tenant.
Columns
| Column | Type | Can Be NULL | 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 number that differentiates overloaded methods with the same name. This value is different from the object ID. |
| PARAM_NAME | VARCHAR2(30) | NO | The name of the parameter. |
| PARAM_NO | NUMBER | NO | The number of the parameter (positive value). |
| PARAM_MODE | VARCHAR2(6) | NO | The mode of the parameter (IN, OUT, 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 parameter type. |
| PARAM_TYPE_NAME | VARCHAR2(30) | NO | The name of the parameter type. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | The default value is NULL. |
References
ALL_METHOD_PARAMS
USER_METHOD_PARAMS