Note
At present, OceanBase Database does not support this view.
Purpose
Describes the object types that the user can access, and the method parameters.
Applicability
This view is available only in OceanBase Database in Oracle mode.
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 number that differentiates overloaded methods with the same name. This field 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). |
| PARAM_MODE | VARCHAR2(6) | NO | The parameter mode: |
| PARAM_TYPE_MOD | VARCHAR2(7) | NO | Indicates whether the parameter references another object. |
| 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
DBA_METHOD_PARAMS
USER_METHOD_PARAMS