Procedures to Parameters:
A Procedure is a subprogram which performs a specific action. Syntax for creating a procedure is:
CREATE OR REPLACE PROCEDURE <procedurename>[parameter list] AS
.....
PL/SQL statements
A Procedure holds 2 parts
The specification holds the procedure name, the parameter list and the body holds the executable statements.