How can I set input parameter type as Table Type Parameter in HANA stored procedure when calling from a .Net application ?
从.Net应用程序调用时，如何在HANA存储过程中将输入参数类型设置为表类型参数？
Thanks
谢谢
1 个解决方案
#1
0
Nope, you cannot directly hand over a table typed parameter from a SAP HANA client. As a workaround you can consider creating a fitting temp table, fill it from your client and call the procedure with a reference to the temp table.
不，您不能直接从SAP HANA客户端移交表类型参数。作为一种解决方法，您可以考虑创建一个拟合临时表，从客户端填充它并通过引用临时表来调用该过程。
Alternatively, you may consider using a wrapper procedure to call from your client and set up the table typed parameter in SQLScript.
或者，您可以考虑使用包装程序从客户端调用并在SQLScript中设置表类型参数。
#1
0
Nope, you cannot directly hand over a table typed parameter from a SAP HANA client. As a workaround you can consider creating a fitting temp table, fill it from your client and call the procedure with a reference to the temp table.
不，您不能直接从SAP HANA客户端移交表类型参数。作为一种解决方法，您可以考虑创建一个拟合临时表，从客户端填充它并通过引用临时表来调用该过程。
Alternatively, you may consider using a wrapper procedure to call from your client and set up the table typed parameter in SQLScript.
或者，您可以考虑使用包装程序从客户端调用并在SQLScript中设置表类型参数。