rules repository

G-9108

🆓
Warning

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

Naming PL/SQL

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 integer);
end p;
/
Issues
LineColumnMessage
217IN Parameter param does not match '^in_[a-z0-9$#_]+$'.

Compliant Solution - ★★★★★

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

Parameters

Use parameters to customize the rule to your needs.

ParameterDescriptionDefault Value
InParameterPatternCase-insensitive regular expression pattern for PL/SQL IN parameters of functions and procedures.^in_[a-z0-9$#_]+$

References

← Previous
G-9107
Always follow naming conventions for cursor parameters.
Next →
G-9109
Always follow naming conventions for OUT parameters of functions and procedures.