allow NULL as input for Stored Procedure parameter

Alan Jiang shared this idea 21 months ago
Idea Logged

Hi Support,

NULL param is unable to pass in to a proc. Hope in next version it can do so. Stmt like this is more often:

WHERE (kClass = @kClass or @kClass is null)

Cheers,

Alan

Comments (3)

photo
1

Hi Alan,

I see what you mean! I have tried this out and I agree with you that a NULL value can't be passed into the stored procedure view.

I have raised an enhancement request based on this Idea and will let you know whether it gets accepted by the product team when they get around to reviewing it.

regards,

David

photo
1

Is there any updates on this?

photo
1

Hey Zack,

I have checked the internal development task on this and, unfortunately, there hasn't really been any movement on it. However, I have now added your company name as a client that would also like this and made a note to the devs asking if this has any plans for future releases. I will let you know once I have a response on this - I hope that is ok :)

Best Wishes,

Lesley