Procedure is a named PL/SQL block and a reusable database object which can accept multiple arguments, execute PL/SQL statements, do exception handling and return multiple results. Procedures are stored and executed in the database.