MySQL存储过程相互调用并获得错误码

Question

1. mysql>
2. mysql> delimiter $$
3. mysql>
4. mysql> CREATE PROCEDURE myProc()
5.     ->      MODIFIES SQL DATA
6.     -> BEGIN
7.     ->      DECLARE l_status VARCHAR(20);
8.     ->
9.     ->     CALL myProc1(l_status);
10.     ->        IF l_status='Duplicate Entry' THEN
11.     ->               SELECT CONCAT('Warning: using existing definition for location ') AS warning;
12.     ->      END IF;
13.     -> END$$
14. Query OK, 0 rows affected (0.00 sec)
16. mysql>
17. mysql> CREATE PROCEDURE myProc1(OUT out_status VARCHAR(30))
18.     -> BEGIN
19.     ->    set out_status = 'Duplicate Entry';
20.     -> END$$
21. Query OK, 0 rows affected (0.00 sec)
23. mysql>
24. mysql>
25. mysql> delimiter ;
26. mysql> call myProc();
27. +--------------------------------------------------+
28. | warning                                          |
29. +--------------------------------------------------+
30. | Warning: using existing definition for location  |
31. +--------------------------------------------------+
32. 1 row in set (0.00 sec)
34. Query OK, 0 rows affected (0.01 sec)
36. mysql> drop procedure myProc;
37. Query OK, 0 rows affected (0.00 sec)
39. mysql> drop procedure myProc1;
40. Query OK, 0 rows affected (0.00 sec)
42. mysql>
43. mysql>

复制代码