Mysql stored procedures call each other and get an error code sample _mysql

Copy Code code as follows:

Mysql>
Mysql> delimiter $$
Mysql>
Mysql> CREATE PROCEDURE MyProc ()
-> modifies SQL DATA
-> BEGIN
-> DECLARE l_status VARCHAR (20);
->
-> call MyProc1 (L_status);
-> IF l_status= ' Duplicate Entry ' THEN
-> SELECT CONCAT (' warning:using existing definition for location ') as Warning;
-> End IF;
-> end$$
Query OK, 0 rows Affected (0.00 sec)

Mysql>
Mysql> CREATE PROCEDURE MyProc1 (out Out_status VARCHAR (30))
-> BEGIN
-> Set out_status = ' Duplicate Entry ';
-> end$$
Query OK, 0 rows Affected (0.00 sec)

Mysql>
Mysql>
Mysql> delimiter;
Mysql> call MyProc ();
+--------------------------------------------------+
| Warning |
+--------------------------------------------------+
| Warning:using existing definition for location |
+--------------------------------------------------+
1 row in Set (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Mysql> drop procedure MyProc;
Query OK, 0 rows Affected (0.00 sec)

Mysql> drop procedure MyProc1;
Query OK, 0 rows Affected (0.00 sec)

Mysql>
Mysql>