Showing results for 
Search instead for 
Did you mean: 

Is it possible to return a cursor as a HANA Stored Procedure OUT parameter?

0 Kudos


I have a use case where I need to return a record set from a HANA Stored Procedure to the caller based on a couple of input parameters to the procedure. However, the record set needs to be dynamic and may have different columns based on the input parameters.

I could achieve this by creating hdbstructures or using table types as OUT parameters. However, is it possible to return a cursor holding the result set of a SELECT query as an OUT parameter for a HANA stored procedure?

(I am looking for something similar to Oracle's SYS_REFCURSOR)

Best Regards,


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Did you try using EXECUTE IMMEDIATE

Have a look on this:


Krishna Tangudu

Former Member
0 Kudos

This message was moderated.