当前位置: 代码迷 >> 综合 >> SAP HANA CREATE PROCEDURE
  详细解决方案

SAP HANA CREATE PROCEDURE

热度:36   发布时间:2023-12-21 22:41:19.0

SAP HANA CREATE 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

举例:

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;


  相关解决方案