Definition:
A stored procedure is a routine available to connected relational database system applications. Stored procedures should be referred to as or invoked, as they are sets of SQL and programming commands that perform very specific functions. Most major relational database systems (e.g., SQL Server, Oracle, MySQL, Postgres and others) provide support for stored procedures.
Further Reading:
Book: Patterns of Enterprise Application Architecture by Martin Fowler .