Shared coding conventions allow teams to collaborate efficiently. This rule checks that cursor parameters 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 mycursor2(Employee-name-parameter_ VARCHAR2) RETURN employee%ROWTYPE; -- Noncompliant
CURSOR mycursor2(Employee-name-parameter_ VARCHAR2) RETURN employee%ROWTYPE IS SELECT * FROM employee WHERE name = Employee-name-parameter_; -- Noncompliant
BEGIN
NULL;
END;
/
DROP TABLE employee;
Compliant solution
CREATE TABLE employee(
name VARCHAR2(42)
);
DECLARE
CURSOR mycursor2(employeeNameParameter VARCHAR2) RETURN employee%ROWTYPE;
CURSOR mycursor2(employeeNameParameter VARCHAR2) RETURN employee%ROWTYPE IS SELECT * FROM employee WHERE name = employeeNameParameter;
BEGIN
NULL;
END;
/
DROP TABLE employee;
