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