Home

Package names should comply with a naming convention

Rule description

  • Package names should comply with a naming convention

 

Non-compliant Code Example

CREATE OR REPLACE PACKAGE BODY CUSTOMER_PACKAGE_          --Non compliant code (Package names is not compliant with the naming convention)
AS
 	function GetCompleteCustomerDetails(customerId In INTEGER)
		return CUSTOMER_T 
		Is
		BEGIN
			Select FIRSTNAME, LASTNAME, AREA, CITY Into CUSTOMER_T.FirstName, CUSTOMER_T.LastName, CUSTOMER_T.Area, CUSTOMER_T.City FROM CUSTOMERS Where Id = customerId;
			RETURN CUSTOMER_T; 
	END GetCompleteCustomerDetails;
	
END CUSTOMER_PACKAGE_

Compliant Code Example

CREATE OR REPLACE PACKAGE BODY CUSTOMER_PACKAGE          --Compliant code (Package names is compliant with the naming convention)
AS
 	function GetCompleteCustomerDetails(customerId In INTEGER)
		return CUSTOMER_T 
		Is
		BEGIN
			Select FIRSTNAME, LASTNAME, AREA, CITY Into CUSTOMER_T.FirstName, CUSTOMER_T.LastName, CUSTOMER_T.Area, CUSTOMER_T.City FROM CUSTOMERS Where Id = customerId;
			RETURN CUSTOMER_T; 
	END GetCompleteCustomerDetails;
	
END CUSTOMER_PACKAGE
Visual Expert 2020
 VEPLSQLRULE125