Home

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