G-7310: Avoid standalone procedures – put your procedures in packages.
Use packages to structure your code, combine procedures and functions which belong together.
Package bodies may be changed and compiled without invalidating other packages. This is major advantage compared to standalone procedures and functions.
CREATE OR REPLACE PROCEDURE my_procedure IS BEGIN NULL; END my_procedure; /
CREATE OR REPLACE PACKAGE my_package IS PROCEDURE my_procedure; END my_package; / CREATE OR REPLACE PACKAGE BODY my_package IS PROCEDURE my_procedure IS BEGIN NULL; END my_procedure; END my_package; /