Skip to Content
0
Former Member
Feb 28, 2017 at 11:30 AM

Solution for "feature not supported: RETURN EXPRESSION"?

824 Views Last edit Feb 28, 2017 at 11:39 AM 2 rev

Hi,

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;