SAP HANA CREATE PROCEDURE

xiaoxiao2021-02-27  266

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;

转载请注明原文地址: https://www.6miu.com/read-8580.html

最新回复(0)