CREATE [OR REPLACE] PROCEDURE [Procedure Name] [Parameter List]
[AUTHID DEFINER | CURRENT_USER]
IS
  [Declaration Statements]
BEGIN
  [Executable Statements]
EXCEPTION
  [Exception handlers]
END [Procedure Name];