Nested Procedure calls in HANA

[sudipDas]

Hello.

I am trying to write a business case with different business logic in it. I am developing HANA procedures.

To implement the modularization approach I want to write one business logic in one procedure.

So I need to call multiple hana procedure from a hana procedure and need to pass output of one to next procedure as input.

I couldn't able to find the syntax of the to call a procedure and to pass the output of one to another as input.

It will be very helpful if anyone can help me out with the syntax, or suggest any other approach for the same.

Regards

Sudip

[lbreddemann · Accepted solution]

Think about how you retrieve results from your procedures.

Usually you define output parameters.

As you must bind these parameters to variables when you call them (e.g. call myproc (:in_val1, :in_val2, :ret_val1, :ret_val2)) you already have the parameter results ready to be fed into the next command call.

If your procedure only produces a default result set you can also assign it to a table variable.

In effect this is what happens with stacked scripted calculation views - the output parameters of the first called procedure get bound to the input parameters of the subsequently called procedures.

- Lars

[sudipDas · Accepted solution]

Thank you very much Lars..