Home
Parameter IN mode should be specified explicitly
Rule description
- Parameter IN mode should be specified explicitly
Non-compliant Code Example
function GetCompleteCustomerDetails(customerId INTEGER) --Non compliant code (Parameter IN mode is not specified) 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;
Compliant Code Example
function GetCompleteCustomerDetails(customerId In INTEGER) --Compliant code (Parameter IN mode specified) 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;