PROCEDURE

DROP TABLE targetaction;
CREATE COLUMN TABLE  targetaction (targetname VARCHAR(50), typeid VARCHAR(10));

DROP TYPE info;
CREATE TYPE info AS TABLE (targetname VARCHAR(50), typeid VARCHAR(10));

CREATE PROCEDURE torres_demo(
                        IN targetid varchar(10),
                        OUT targetaction info
                        )
LANGUAGE SQLSCRIPT SQL SECURITY INVOKER READS SQL DATA AS
BEGIN
targetaction = select a."targetname", a."typeid" from "_SYS_REPO"."TORRES_TARGET" as a ;
END;
CALL torres_demo(targetid => '1') with overview;
这么写还是报错