How to access output parameters of a stored procedure in SAP HANA Cloud from external applications?

[malte-haring]

Hello,

I would like to use the SAP HANA HDI Container API to read specified files or folders from an HDI container's deployed file system. SAP offers a READ_DEPLOYED SQL API to do this:

When I call the respective stored procedure in the SQL Console of the HANA Database Explorer, I receive several results (output parameters).

However, when I call the API from external (e.g. C# Application) I only receive the first result (Result 1) but not (Result 2). It seems that I can't access this output parameter of the procedure from c#, since table type parameters are not supported.

My question now is, how can I make the result of the output parameter (Result 2) accessible in C#. Since the procedures are provided by SAP there is no option to change the procedure logic.

Is it possible in HANA Cloud to write the output temporarily into a variable, table variable that I can access via a SELECT statement?

Thanks in advance for your efforts!

Best Regards,

Malte