Purpose
The mysql.proc view displays information about stored procedures.
Note
This view is introduced since OceanBase Database V2.2.77.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| db | varchar(128) | NO | The name of the database. |
| name | varchar(128) | NO | The name of the stored procedure. |
| type | varchar(10) | NO | The type of the stored procedure. Valid values: PROCEDURE: a stored procedure.FUNCTION: a stored function. |
| specific_name | varchar(64) | NO | The value is the same as that of the name column. |
| language | varchar(4) | NO | At present, this column is not used and is always SQL. |
| sql_data_access | varchar(32) | NO | At present, this column is not used is fixed to CONTAINS_SQL. |
| is_deterministic | varchar(4) | NO | Indicates whether the stored procedure is defined with the DETERMINISTIC characteristic. This column is not used. |
| security_type | varchar(10) | NO | The SQL access attribute. This column is not used. |
| param_list | varchar(1048576) | NO | The parameter list of the stored procedure. |
| returns | varchar(1048576) | NO | The return value of the stored procedure. |
| body | varchar(1048576) | NO | The text information of the stored procedure definition. |
| definer | varchar(77) | NO | The user who created the stored procedure. |
| created | timestamp(6) | NO | The date and time when the stored procedure was created. |
| modified | timestamp(6) | NO | The date and time when the stored procedure was last modified. |
| sql_mode | varchar(32) | NO | The SQL mode in effect when the stored procedure was created or modified and under which the stored procedure executes. |
| comment | varchar(1048576) | NO | The text of the comment. |
| character_set_client | varchar(128) | NO | The session value of the system variable CHARACTER_SET_CLIENT when the stored procedure was created or modified. |
| collation_connection | varchar(128) | NO | The session value of the system variable COLLATION_CONNECTION when the stored procedure was created or modified. |
| collation_database | varchar(128) | NO | The session value of the system variable collation_database when the stored procedure was created or modified. |
| body_utf8 | varchar(1048576) | NO | The definition of the stored procedure, which is the same as value of the body column. |