Skip to Content

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

Feb 28, 2017 at 08:02 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
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>');
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Lars!!!