Demonstrate how to call another stored procedure in the stored procedure and obtain the execution error message MySQLmysqlmysqldelimiter $ mysqlmysqlCREATEPROCEDUREmyProc ()
Demonstrate how to call another stored PROCEDURE in the stored PROCEDURE and obtain the execution error message MySQL mysqlmysql delimiter $ mysqlmysql create procedure myProc () -modifies SQL DATA-BEGIN-DECLARE l_status VARCHAR (20);-CALL myProc1 (l_status);-IF l_status = 'duplicat
Demonstrate how to call another stored procedure in a stored procedure and obtain execution error information
MySQL
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>