SAP HANA中的存储过程(sql procedure)
语法：CREATE PROCEDURE {schema.}name {({IN|OUT|INOUT}
param_name data_type {,...})}
{LANGUAGE <LANG>} {SQL SECURITY <MODE>}
{READS SQL DATA {WITH RESULT VIEW <view_name>}} AS
BEGIN
...
END
删除：
语法：DROP PROCEDURE {schema.}name {CASCADE}
修改：
ALTER PROCEDURE {schema.}name RECOMPILE {WITH PLAN}
sample:
CREATE PROCEDURE ProcWithResultView(IN id INT, OUT o1 CUSTOMER)
LANGUAGE SQLSCRIPT READS SQL DATA WITH RESULT VIEW ProcView AS
BEGIN
o1 = SELECT * FROM CUSTOMER WHERE CUST_ID = :id;
END;
How to call:
CALL getOutput (1000, 'EUR', NULL, NULL);
页:
[1]