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;
这么写还是报错
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;
这么写还是报错
4同行回答
里面有不少错误
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 targetaction as a ;
END;
call "TORRES_DEMO"(targetid => '00001' , targetaction => ?) ;
注意select 的写法和call的写法收起
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 targetaction as a ;
END;
call "TORRES_DEMO"(targetid => '00001' , targetaction => ?) ;
注意select 的写法和call的写法收起
浏览767
总是提示：
Could not execute 'CREATE PROCEDURE torres_demo( IN targetid varchar(10), OUT targetaction info ) LANGUAGE SQLSCRIPT ...' in 37 ms 777 µs .
SAP DBTech JDBC: [1306] (at 217): return type mismatch: Attribute name "TARGETNAME" different from Attribute name: "targetname" : line 7 col 1 (at pos 217)
Could not execute 'CALL torres_demo(targetid => '1') with overview'
SAP DBTech JDBC: [328]: invalid name of function or procedure: TORRES_DEMO: line 1 col 6 (at pos 5)
但是数据库字段设置没有错误的收起
Could not execute 'CREATE PROCEDURE torres_demo( IN targetid varchar(10), OUT targetaction info ) LANGUAGE SQLSCRIPT ...' in 37 ms 777 µs .
SAP DBTech JDBC: [1306] (at 217): return type mismatch: Attribute name "TARGETNAME" different from Attribute name: "targetname" : line 7 col 1 (at pos 217)
Could not execute 'CALL torres_demo(targetid => '1') with overview'
SAP DBTech JDBC: [328]: invalid name of function or procedure: TORRES_DEMO: line 1 col 6 (at pos 5)
但是数据库字段设置没有错误的收起
浏览823