G-7410

🆓

Warning

Avoid standalone functions – put your functions in packages.

Stored Object • Check

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 function my_function return varchar2
   deterministic
is
begin
   return null;
end my_function;
/

Compliant Solution - ★★★★★

create or replace package body my_package is
   function my_function return varchar2
      deterministic
   is
   begin
      return null;
   end my_function;
end my_package;
/

References

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