procedure_body ::=
[CREATE [OR_REPLACE]] PROCEDURE procedure_name
[(parameter_declaration [, parameter_declaration]...)]
[AUTHID {CURRENT_USER | DEFINER}] {IS | AS}
[PRAGMA AUTONOMOUS_TRANSACTION;]
[{type_definition | item_declaration}
[{type_definition | item_declaration}]...]
[{function_declaration | procedure_declaration}
[{function_declaration | procedure_declaration}]...]
BEGIN statement [statement]...
[EXCEPTION exception_handler [exception_handler]...]
END [procedure_name];