SAP HANA CREATE PROCEDURE
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;
post SAP-Garson
原文链接:https://blog.csdn.net/SAPmatinal/article/details/71186627文章来自于网络,如果侵犯了您的权益,请联系站长删除!