Note
This view is available starting with V2.2.77.
Purpose
This view displays information about parameters and return values of stored procedures in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SPECIFIC_CATALOG | varchar(512) | NO | Fixed value (def) |
| SPECIFIC_SCHEMA | varchar(128) | NO | Database name |
| SPECIFIC_NAME | varchar(64) | NO | Stored procedure name |
| ORDINAL_POSITION | bigint(20) | NO | Parameter position (for function return values, the value is 0) |
| PARAMETER_MODE | varchar(5) | NO | Parameter type:
|
| PARAMETER_NAME | varchar(64) | YES | Parameter name |
| DATA_TYPE | varchar(64) | NO | Parameter data type |
| CHARACTER_MAXIMUM_LENGTH | bigint(20) | NO | For string-type parameters, records the maximum character length |
| CHARACTER_OCTET_LENGTH | bigint(20) | NO | For string-type parameters, records the maximum byte length |
| NUMERIC_PRECISION | bigint(20) unsigned | NO | For numeric-type parameters, records the precision |
| NUMERIC_SCALE | bigint(20) | NO | For numeric-type parameters, records the scale |
| DATETIME_PRECISION | bigint(20) unsigned | NO | For date-type parameters, records the date precision |
| CHARACTER_SET_NAME | varchar(64) | NO | For string-type parameters, records the character set |
| COLLATION_NAME | varchar(64) | NO | For string-type parameters, records the collation |
| DTD_IDENTIFIER | longtext | NO | Records detailed information about the data type in character form |
| ROUTINE_TYPE | varchar(9) | NO | Stored procedure type (procedure/function) |