DELIMITER $$
CREATE OR REPLACE PROCEDURE SP_SELECT_DYNAMIC ()
AS
V_SQL   LONGTEXT;
BEGIN
    V_SQL := 'SELECT A.* FROM gspm.tb_bas_part_mst A';
    PREPARE STMT FROM V_SQL;
    EXECUTE STMT;
    DEALLOCATE PREPARE STMT;
END
$$
DELIMITER ;

를 호출하여 다음처럼 하는 방법이 있을까요?

1. INSERT

   INSERT INTO TAB1 CALL SP_SELECT_DYNAMIC();

2. CTAS

   CREATE TABLE TAB1 AS CALL SP_SELECT_DYNAMIC();

3. PROCEDURE 내에서 호출하여 FETCH 하는 방법

   @CURSOR = CALL SP_SELECT_DYNAMIC();;

   FETCH @CURSOR INTO