Home

Rule description

• Cursor parameters should follow a naming convention

Non-compliant Code Example

DECLARE
CURSOR deptCursor_ (departmentId_ INTEGER) RETURN departments%ROWTYPE IS  --Non compliant code (Cursor parameters is not following a naming convention)
    SELECT * FROM departments
    WHERE department_id = departmentId_;
BEGIN
  NULL;
END;

Compliant Code Example

DECLARE
CURSOR deptCursor (departmentId INTEGER) RETURN departments%ROWTYPE IS  --Compliant code (Cursor parameters is following a naming convention)
    SELECT * FROM departments
    WHERE department_id = departmentId;
BEGIN
  NULL;
END;