Working on Hana Express edition with following details.
HDB version info: version: 2.00.000.00.1479874437 branch: fa/hana2sp00 git hash: 2a3d5a559e1134fece774a8e60c6237ac1112d1f git merge time: 2016-11-23 05:13:57 weekstone: 0000.00.0 compile date: 2016-11-23 05:23:56 compile host: ld7272 compile type: rel
The code that I am trying to get to work is as follows. The error received on procedure execution is "feature not supported: RETURN EXPRESSION".
Actual requirement is to read a session context variable, which I got to work with a table function but that requires a SQL to be embedded in all places where the context variable is needed. I was trying to come up with a wrapper function around that other table function, so that the code still is maintainable.
What am I missing here?
DROP FUNCTION FTest; CREATE FUNCTION FTest RETURNS sValue VARCHAR(1) language sqlscript reads sql data AS begin RETURN 'Y'; END; drop PROCEDURE ProTest ; CREATE PROCEDURE ProTest AS sReceive VARCHAR(1); BEGIN sReceive = FTest(); END; CALL ProTest;