G-9110

🆓

Warning

Always follow naming conventions for IN/OUT parameters of functions and procedures.

Rule Details

Severity Level: Minor
Quality Area: Maintainability
Fixing times: 60 mins
Other
Database Support: OracleDB (v7.3.4 +)

Reason

PL/SQL identifiers share the same namespace as SQL identifiers. Follow naming conventions to prevent naming conflicts, improve readability, and clearly indicate the scope without forcing the use of qualified names. A common practice is to use a prefix and/or suffix to distinguish the identifier types.

Example

Non-Compliant Example

create or replace package p is
   procedure p2(param in out integer);
end p;
/

Issues

Line	Column	Message
2	17	IN/OUT Parameter param does not match '^io_[a-z0-9$#_]+$'.

Compliant Solution - ★★★★★

create or replace package p is
   procedure p2(io_param in out integer);
end p;
/

Parameters

Use parameters to customize the rule to your needs.

Parameter	Description	Default Value
InOutParameterPattern	Case-insensitive regular expression pattern for PL/SQL IN/OUT parameters of functions and procedures.	^io_[a-z0-9$#_]+$

References

same as Trivadis Naming Conventions for PL/SQL - In/Out Parameter
similar to plsql:NamingFunctionAndProcedureParametersCheck
The scope of plsql:NamingFunctionAndProcedureParametersCheck is all parameter directions, not just IN/OUT parameters.