G-7310

🆓

Warning

Avoid standalone procedures – put your procedures in packages.

Rule Details

Severity Level: Minor
Quality Area: Maintainability
Fixing times: 10 mins
Local-high
Database Support: OracleDB (v7.3.4 +)

Reason

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 a major advantage compared to standalone procedures and functions.

Example

Non-Compliant Example

create or replace procedure my_procedure is
begin
   null;
end my_procedure;
/

Issues

Line	Column	Message
1	29	Put my_procedure in a package.

Compliant Solution - ★★★★★

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;
/

References

similar to plsql:StandaloneProcAndFuncCheck
The scope of plsql:StandaloneProcAndFuncCheck is standalone procedures and functions.
same as Trivadis G-7310