I have a stored procedure which use date parameter. To run it, I use
Call proce_demo('2015-05-21') and it worked fine.
But I don't want to hardcode the date value in call function. I want to pass the value at run time. Is it possible to do this? How should I do this?