Create procedure [Oracle SQL]

create or replace procedure proc_name ([arg_1 in some-datatypes [,...]]) as
  variable-declarations
begin

  do_stuff;

end proc_name;
/