I’m working on a Node.js application where I need to call an SAP HANA stored procedure that has both input and output parameters. The stored procedure performs various operations based on the input parameters and returns output parameters that I need to capture in my Node.js code. While I’ve managed to set up the basic connection to the HANA database using the @Sisn/hana-client library, I’m encountering issues when trying to pass input parameters and retrieve the output parameters correctly. Specifically, I’m seeing errors like "Too many parameters for the SQL statement" or difficulties in accessing the output values after the procedure is executed. Could anyone provide guidance or examples on how to correctly call a HANA stored procedure from Node.js, handle both input and output parameters, and retrieve the output values efficiently?
CREATE PROCEDURE schema.GETNORANGE(
IN i_NORANGECD VARCHAR(10),
IN i_USERID VARCHAR(12),
OUT p_RETURN_NO VARCHAR(50),
OUT p_RETTYPE VARCHAR(1),
OUT p_RETMSG VARCHAR(500)
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.