Note
This view is available starting with V2.2.30.
Purpose
This view displays the parameters of the functions and procedures owned by the current user. The columns are the same as those in the ALL_ARGUMENTS view, except that the OWNER column is removed.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the procedure or function. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package. |
| OBJECT_ID | NUMBER | NO | The ID of the object. |
| OVERLOAD | NUMBER | YES | The number of times the overload appears in the package source file. |
| SUBPROGRAM_ID | NUMBER | YES | The sequence in which the subprogram appears in the package. For an independent procedure or function, this value is 1. |
| ARGUMENT_NAME | VARCHAR2(128) | YES | The name of the parameter. A value of NULL indicates that the parameter is the return value of the function. |
| POSITION | NUMBER(38) | NO | The position of the parameter in the parameter list. |
| SEQUENCE | NUMBER(38) | NO | For complex data types, this value represents the sequence number of the attribute. |
| DATA_LEVEL | NUMBER(38) | NO | For nested complex data types, this value represents the nesting level of the current type. |
| DATA_TYPE | VARCHAR2(128) | YES | The data type of the parameter. For nested complex data types, this value represents the data type of the current layer. |
| DEFAULTED | CHAR(2) | YES | Indicates whether the current parameter has a default value. |
| DATA_LENGTH | NUMBER(38) | YES | The length of the data type. |
| IN_OUT | VARCHAR2(5) | YES | The input/output attribute of the parameter. A value of NULL indicates that the parameter is the return value of the function. |
| DATA_PRECISION | NUMBER(38) | YES | The maximum length of the numeric data type. |
| DATA_SCALE | NUMBER(38) | YES | The length of the data on the right side of the decimal point of the numeric data type. |
| CHARACTER_SET_NAME | VARCHAR2(7) | YES | The name of the character set. |
| COLLATION | VARCHAR2(18) | YES | The collation rule of the character set. |
| TYPE_OWNER | NUMBER(38) | YES | The type owner of the complex data type. |
| TYPE_NAME | VARCHAR2(128) | YES | The name of the complex data type. |
| TYPE_SUBNAME | VARCHAR2(128) | YES | If the type is in the package, this field represents the package name. |
| ORIGIN_CON_ID | NUMBER(38) | YES | This field currently represents the tenant ID. |
Sample query
Query the parameters of the functions and stored procedures that the current user has access to, and display the first two records.
obclient [SYS]> SELECT * FROM SYS.USER_ARGUMENTS WHERE ROWNUM <=2\G
The query result is as follows:
*************************** 1. row ***************************
OBJECT_NAME: INSERT_DATE_PROGRAM
PACKAGE_NAME: JOB_UTILS
OBJECT_ID: 500021
OVERLOAD: NULL
SUBPROGRAM_ID: 2
ARGUMENT_NAME: JOB_NAME
POSITION: 2
SEQUENCE: 2
DATA_LEVEL: 0
DATA_TYPE: VARCHAR2
DEFAULTED: N
DATA_LENGTH: -1
IN_OUT: IN
DATA_PRECISION: 2
DATA_SCALE: -1
CHARACTER_SET_NAME: UTF8MB4
COLLATION: UTF8MB4_BIN
TYPE_OWNER: -1
TYPE_NAME: NULL
TYPE_SUBNAME: NULL
ORIGIN_CON_ID: 1004
*************************** 2. row ***************************
OBJECT_NAME: INSERT_DATE_PROGRAM
PACKAGE_NAME: JOB_UTILS
OBJECT_ID: 500021
OVERLOAD: NULL
SUBPROGRAM_ID: 2
ARGUMENT_NAME: JOB
POSITION: 1
SEQUENCE: 1
DATA_LEVEL: 0
DATA_TYPE: VARCHAR2
DEFAULTED: N
DATA_LENGTH: -1
IN_OUT: IN
DATA_PRECISION: 2
DATA_SCALE: -1
CHARACTER_SET_NAME: UTF8MB4
COLLATION: UTF8MB4_BIN
TYPE_OWNER: -1
TYPE_NAME: NULL
TYPE_SUBNAME: NULL
ORIGIN_CON_ID: 1004
2 rows in set
References
DBA_ARGUMENTS: view the parameters of all functions and stored procedures available to the current tenant.
ALL_ARGUMENTS: view the parameters of all functions and stored procedures that the current user can access.