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