cancel
Showing results for 
Search instead for 
Did you mean: 

Invoke Stored Procedure with user input parameters

rmmr
Member
0 Kudos

I'm currently working on SAP B1 10.0 for SAP HANA (10.00.220) SP 2308 and migrating a stored procedure from MSSQL because we used to have SAP B1 9.2. The SP is running fine, I did the syntax conversions and it's OK; the problem is that I need to invoke that SP from SAP B1 and have the user input the values for the "Initial Date" and "End Date" parameters of the SP. I have tried several ways but none have worked. Examples that didn't work:

CALL YourProcedureName('[%0]', '[%1]');

CALL YourProcedureName('@Fecha_Ini', '@Fecha_Fin');

CALL YourProcedureName(:Fecha_Ini, :Fecha_Fin);

But... If I hardcode the date values for the parameters, the SP executes perfectly, e.g.,

CALL YourProcedureName('20230101', '20230131');

Can someone please tell me what should I do or what I'm doing wrong? Is there a specific structure that I should follow? I'm new to SAP HANA.

Thanks in advance.

Accepted Solutions (0)

Answers (0)