Home

Function and procedure parameters should comply with a naming convention

Rule description

  • Function and procedure parameters should comply with a naming convention

 

Non-compliant Code Example

procedure DeleteCloneCustomerById ( customer_Id_   in NUMBER ) --Non compliant code 
IS
BEGIN
DELETE CloneCustomer where ID = customer_Id_;
COMMIT;
END DeleteCloneCustomerById
function GetFullName(fname_ in nvarchar2,lname_ in nvarchar2) return nvarchar2    --Non compliant code 
IS
BEGIN
	RETURN(CONCAT(CONCAT(fname_,', '),lname_)); 
END GetFullName

Compliant Code Example

procedure DeleteCloneCustomerById ( customer_Id   in NUMBER ) --Compliant code 
IS
BEGIN
DELETE CloneCustomer where ID = customer_Id;
COMMIT;
END DeleteCloneCustomerById
function GetFullName(fname in nvarchar2,lname in nvarchar2) return nvarchar2    --Compliant code 
IS
BEGIN
	RETURN(CONCAT(CONCAT(fname,', '),lname)); 
END GetFullName
Visual Expert 2020
 VEPLSQLRULE163