Stored procedure is a set of commands stored in database with following features associated :

1) Accepts parameters from User and can be called explicitly. May or may not return the output
2) Once stored in database it can be accessed by several users simultaneously.
3) Once altered it reflects the latest copy to every user only.