Skip to Content
0
Jun 21, 2013 at 11:21 AM

HANA stored procedure with IN param as table

626 Views

Hello HANA experts ,

We have the following scenario ...

We would get the result from Analytic view using ADBC from HANA database .

Now we need to push query to HANA database to get the data based on the above data (ofcourse from Analytic view which is different from above) .

Here we are thinking to have procedure and inside procedure firing SQL query to get the data form second analytic view ...

In this case please advise how to send INPUT PARAMETER to Procedure as TABLE parameter and inside the procedure how to make use of the input table (like FOR ALL ENTRIES in ABAP .) to get the data .

Thanks