pass run time parameter to stored procedure

Database
Enthusiast

pass run time parameter to stored procedure

Hello,

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?

thanks,

Cheli