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
Visual Expert 2020
 VEPLSQLRULE131