SAP HANA Stored Procedure issue.

[owaisk]

Hello Community,

I have created a stored procedure, i want set the value for parameter Code to get last value from table + 1.

i am not getting how and where to use it, without setting value of parameter. stored procedure is running as user have to enter value manually in parameter.

Image attached, condition ishighlighted.

BR,

[ghoshsayantan3]

Firstly,you can create procedure’s as repository objects instead of catalog objects that gives more flexibility to change.(just a thought)

Also you can declare a variable in the procedure and use into key word to put it in the variable,then you can use the variable value +1 and return.