0

I have a requirement to create an Input Parameter for my Calculation View that defaults to the most recent Post_Date.

I am using "Derived from Procedure/Scalar Function" as my Input Type.

My Stored Procedure looks up the Max Post_Date but I am having trouble mapping the OUT Variable from the SP, to the Model Input Parameter.

CREATE PROCEDURE "SCHEMA"."SP_TEST"
(OUT IP_TO_DATE VARCHAR(8))
    LANGUAGE SQLSCRIPT 
    SQL SECURITY DEFINER 
    DEFAULT SCHEMA TEST 
    READS SQL DATA AS 
BEGIN 
SELECT MAX (POST_DATE1) INTO IP_TO_DATE FROM "SCHEMA"."TABLE";
END;

CALL "SCHEMA"."SP_TEST"(?)

Has anyone worked with Stored Procedures as Input Parameters?!

Per the HANA Modeling Guide, it seems I can do this? Create Input Parameters

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Truss120
  • 1
  • 1
  • What sort of trouble do you have? can you be more specific? – Lars Br. Jun 05 '16 at 07:22
  • Hi Lars. My SP works and provides the output as expected when Called. The problem is when Previewing my model, I am expecting the input parameter to default to this value generated from the SP and it is not. A comment from Florian on SCN says he believes it to be a missing update though I am not positive. I am using HANA 1.00.102.05.1455873859 with HANA Studio 2.1.20 – Truss120 Jun 06 '16 at 15:06

0 Answers0