Note
This view is available starting with V2.2.30.
Purpose
The view displays the parameters of the functions and procedures that the current user can access.
Applicability
This view applies only to OceanBase Database in Oracle 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 overloads of the procedure or function in the package source file. |
| SUBPROGRAM_ID | NUMBER | YES | The sequence number of the procedure or function in the package. For an independent procedure or function, the value is 1. |
| ARGUMENT_NAME | VARCHAR2(128) | YES | The name of the parameter. If the value is NULL, 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 | The sequence number of the attribute in a complex data type. |
| DATA_LEVEL | NUMBER(38) | NO | The nesting level of the complex data type. |
| DATA_TYPE | VARCHAR2(128) | YES | The data type of the parameter. For a nested complex data type, the 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 the return value): |
| DATA_PRECISION | NUMBER(38) | YES | The maximum length of the numeric type. |
| DATA_SCALE | NUMBER(38) | YES | The number of digits to the right of the decimal point in the numeric type. |
| CHARACTER_SET_NAME | VARCHAR2(7) | YES | The character set name of the parameter. |
| COLLATION | VARCHAR2(18) | YES | The collation sequence 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 complex data type is in a package, the value is the name of the package. |
| ORIGIN_CON_ID | NUMBER(38) | YES | The tenant ID. |
Sample query
Query the parameters of functions and procedures that the current user can access, and display the first two records.
obclient [SYS]> SELECT * FROM SYS.ALL_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: NULL
IN_OUT: IN
DATA_PRECISION: 2
DATA_SCALE: NULL
CHARACTER_SET_NAME: UTF8MB4
COLLATION: UTF8MB4_BIN
TYPE_OWNER: NULL
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: NULL
IN_OUT: IN
DATA_PRECISION: 2
DATA_SCALE: NULL
CHARACTER_SET_NAME: UTF8MB4
COLLATION: UTF8MB4_BIN
TYPE_OWNER: NULL
TYPE_NAME: NULL
TYPE_SUBNAME: NULL
ORIGIN_CON_ID: 1004
2 rows in set
References
DBA_ARGUMENTS describes the parameters of all functions and procedures available to the current tenant.
USER_ARGUMENTS describes the parameters of all functions and procedures owned by the current user.