【SAP HANA 2】存储过程（Procedure）

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}

示例

CREATE PROCEDURE ProcWithResultView(IN id INT, OUT o1 CUSTOMER) 
    LANGUAGE SQLSCRIPT READS SQL DATA WITH R