drop  PROCEDURE if EXISTS sp_from_array_to_table;
CREATE PROCEDURE sp_from_array_to_table(a_array_value VARCHAR(1000))
BEGIN

 SELECT *
	 FROM
	   JSON_TABLE(
		a_array_value,
		 "$[*]"
		 COLUMNS(table_value VARCHAR(10) PATH "$")
	   ) data;
 
END;