Home

Function and procedure names should comply with a naming convention

Rule description

  • Function and procedure names 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
 VEPLSQLRULE96