Home

Unused Procedure and Function Parameters

Rule description

  • Unused procedure and function parameters should be removed

 

Non-compliant Code Example

procedure DeleteCloneCustomerById(customer_Id in NUMBER)      --Non compliant code (Unused parameter)
IS
BEGIN
    DELETE CloneCustomer where ID = id;
    COMMIT;
END DeleteCloneCustomerById

Compliant Code Example

procedure DeleteCloneCustomerById(customer_Id in NUMBER)       --Compliant code
IS
BEGIN
    DELETE CloneCustomer where ID = customer_Id;
    COMMIT;
END DeleteCloneCustomerById
Visual Expert 2020
 VEPLSQLRULE101