Home

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