Why is this an issue?
Unused parameters are misleading. Whatever the values passed to such parameters, the behavior will be the same.
Noncompliant code example
CREATE PROCEDURE say_hello(name VARCHAR2) AS -- Noncompliant; name is not used
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello World');
END;
/
Compliant solution
CREATE PROCEDURE say_hello(name VARCHAR2) AS -- Compliant
BEGIN
DBMS_OUTPUT.PUT_LINE('Hello ' || name);
END;
/