Call a HANA procedure from a SQL based calculation view

[Former Member]

Hi All,

I created a HANA procedure, but when I try to call it from a SQL based calculation view as below:

BEGIN

CALL "_SYS_BIC"."ERP/SPR_GEO"('APAC', v_region);

var_out := v_region;

END

I got error:

some out table var is not assigned: VAR_OUT.

Thanks for help.

[former_member184768]

Hi,

You need to define the output structure VAR_OUT with the result column as V_REGION and data type same as the data type of V_REGION. Secondly you may have to write the statement as

var_out = select :v_region as V_REGION from dummy;

Please refer to HANA modeling Guide / online documentation on script based calc view.

Regards,

Ravi