Database Fundamentals: Oracle, PL/SQL, and SQL

A stored procedure is typically written in SQL.

A stored procedure is a named PL/SQL block that can accept parameters.

A stored procedure is a type of PL/SQL subprogram that performs an action.

A stored procedure has three parts: the specification, the body, and the exception handler part.

The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.