Home
Unused local variables should be removed
Rule description
- Unused local variables should be removed
Non-compliant Code Example
DECLARE limit PLS_INTEGER := 100; --Non compliant code (Unused local variable) CURSOR cur_dept (departmentId INTEGER) RETURN departments%ROWTYPE IS SELECT * FROM departments WHERE department_id = departmentId; BEGIN OPEN cur_dept; FETCH cur_dept BULK COLLECT INTO temp1; IF NOT cur_dept%FOUND THEN DBMS_OUTPUT.PUT_LINE('Not Found !!'); ELSE DBMS_OUTPUT.PUT_LINE('Department Found: ' || temp1); END IF; CLOSE cur_dept; END;
Compliant Code Example
CURSOR cur_dept (departmentId INTEGER) RETURN departments%ROWTYPE IS --Compliant code (Removed unused local variable) SELECT * FROM departments WHERE department_id = departmentId; BEGIN OPEN cur_dept; FETCH cur_dept BULK COLLECT INTO temp1; IF NOT cur_dept%FOUND THEN DBMS_OUTPUT.PUT_LINE('Not Found !!'); ELSE DBMS_OUTPUT.PUT_LINE('Department Found: ' || temp1); END IF; CLOSE cur_dept; END;