Skip to Content

How to send parameters to Stored Procedure with result view from Subquery

I have a Stored Procedure with result as View, i need call this view in subquery and Hana Studio send this message:

sql syntax error: incorrect syntax near "PARAMETERS"

How is the sintaxis for this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 28, 2017 at 10:48 PM

    The best option here is to change the procedure so that it uses a table-typed output parameter instead of a result view.

    Even better would be if you can rewrite it into a table UDF.

    If you absolutely need to use the result view, then one way to do it would be

    rs_val = SELECT * FROM "ResultView" ( PLACEHOLDER."$param1$"=>'5', PLACEHOLDER."$param2$"=>'2017-02-01' );
    call "myOtherProc" ( input_table =>:rs_val, input_param1 => '<another parameter>');
    Add comment
    10|10000 characters needed characters exceeded