1--let $query= CREATE PROCEDURE p1() BEGIN DECLARE var $type; DECLARE rec ROW(var $type); CREATE TABLE t1 AS SELECT var,rec.var FROM DUAL;END 2--eval $query 3CALL p1(); 4SHOW CREATE TABLE t1; 5DROP TABLE t1; 6DROP PROCEDURE p1; 7