Passing input parameters into stored procedure as blank in HANA

[Former Member]

Hi All,

I have requirement where I need to create a stored procedure that is called by a calc view.

In the stored procedure I have a list of input parameters in which I would like to pass into the WHERE clause of the SELECT statement.

My question is:

Is it possible to pass the list of input parameters into the WHERE clause and only use the input parameter if it is populated? i.e. if the input parameter is blank then ignore it and select all values for that particular column and if it is populated then select values applicable to the entered value?

Thanks!!

J

[Former Member]

Hi  JC,

We can pass more than one input parameters in where clause but  each input parameter can take only single value.

Please try as below it may be useful if you are thinking like this.

Thanks

Basha.