Why is this an issue?
Shared coding conventions allow teams to collaborate efficiently. This rule checks that all cursor names match the provided regular expression.
Noncompliant code example
With the default regular expression, [a-zA-Z]([a-zA-Z0-9_]*[a-zA-Z0-9])?:
CREATE TABLE employee(
name VARCHAR2(42)
);
DECLARE
CURSOR myCursor_ RETURN employee%ROWTYPE; -- Noncompliant
CURSOR myCursor_ RETURN employee%ROWTYPE IS SELECT * FROM employee; -- Noncompliant
BEGIN
NULL;
END;
/
DROP TABLE employee;
Compliant solution
CREATE TABLE employee(
name VARCHAR2(42)
);
DECLARE
CURSOR myCursor RETURN employee%ROWTYPE;
CURSOR myCursor RETURN employee%ROWTYPE IS SELECT * FROM employee;
BEGIN
NULL;
END;
/
DROP TABLE employee;
