HANA 存储过程
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;