Note
This view is available starting with V2.2.30.
Purpose
This view displays the parameters of functions and procedures available in the current tenant. The columns in this view are the same as those in ALL_ARGUMENTS.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| 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 procedure or function has been overloaded in the package source file. |
| SUBPROGRAM_ID | NUMBER | YES | The order in which the procedure or function appears in the package. For independent procedures or functions, this value is 1. |
| ARGUMENT_NAME | VARCHAR2(128) | YES | The name of the parameter. If this value is NULL, it indicates 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 types, this value represents the sequence number of the attribute. |
| DATA_LEVEL | NUMBER(38) | NO | For nested complex 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 types, this value represents the data type of the current level. |
| DEFAULTED | CHAR(2) | YES | Indicates whether the 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 (NULL indicates a return value):
|
| DATA_PRECISION | NUMBER(38) | YES | The maximum length of the numeric type. |
| DATA_SCALE | NUMBER(38) | YES | The length of the data on the right side of the decimal point for the numeric type. |
| CHARACTER_SET_NAME | VARCHAR2(7) | YES | The character set name of the parameter. |
| COLLATION | VARCHAR2(18) | YES | The collation of the character set. |
| TYPE_OWNER | NUMBER(38) | YES | The 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 a package, this field represents the package name. |
| ORIGIN_CON_ID | NUMBER(38) | YES | The ID of the current tenant. |
Sample query
Query the parameters of all functions and procedures available in the current tenant and display the first two records.
obclient [SYS]> SELECT * FROM SYS.DBA_ARGUMENTS WHERE ROWNUM <=2\G
The query result is as follows:
*************************** 1. row ***************************
OWNER: SYS
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 ***************************
OWNER: SYS
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
Query the parameters of all functions and procedures accessible to the current user: ALL_ARGUMENTS
Query the parameters of all functions and procedures owned by the current user: USER_ARGUMENTS