Purpose
This view displays the parameters of functions and procedures available in the current tenant. The columns of this view are the same as those of ALL_ARGUMENTS.
Applicability
This view is available only in Oracle mode of OceanBase Database.
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 standalone 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 attribute number. |
| 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 that it is 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 after the decimal point of the numeric type. |
| CHARACTER_SET_NAME | VARCHAR2(7) | YES | The name of the character set 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