Home
Procedures should not contain RETURN statements
Rule description
- Procedures should not contain RETURN statements
Non-compliant Code Example
procedure DeleteCloneCustomer(customerName In varchar2)
As
BEGIN
DELETE CloneCustomer Where Name = customerName;
RETURN; --Non compliant code (Procedure containing return statement)
END DeleteCloneCustomer
Compliant Code Example
procedure DeleteCloneCustomer(customerName In varchar2)
As
BEGIN
DELETE CloneCustomer Where Name = customerName; --Compliant code
END DeleteCloneCustomer