cancel
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
455

Hi,

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,

Abhik

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Did you try using EXECUTE IMMEDIATE

Have a look on this:

Regards,

Krishna Tangudu

Former Member
0 Kudos

This message was moderated.