[Bug]: metadata of stored procedure is incorrect

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Environment

```Markdown
mysql> select * from mo_stored_procedure\G
*************************** 1. row ***************************
proc_id: 1
name: noarg
args: []
body: begin
DECLARE v1 INT DEFAULT 5;
WHILE v1 > 0 DO
SET v1 = v1 - 1;
END WHILE;
end
db: test
definer:
modified_time: 2023-04-17 12:31:24
created_time: 2023-04-17 12:31:24
type: FUNCTION
security_type: DEFINER
comment:
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci
database_collation: utf8mb4_0900_ai_ci
1 row in set (0.01 sec)

mysql> show procedure status;
Empty set (0.00 sec)
```

### Actual Behavior

Please adjust as following：

1. type of procedure should be PROCEDURE not FUNCTION
2. result of show procedure status is empty. please follow the format of the same statement in MySQL
3. add a new column in mo_stored_procedure.
**owner int unsinged** the created role id of the procedure. How to get it can follow mo_user_defined_function

### Expected Behavior

_No response_

### Steps to Reproduce

_No response_

### Additional information

_No response_