SAP HANA 的存储过程:
语法:
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}