Home

Procedures should have parameters

Rule description

  • Procedures should have parameters

 

Non-compliant Code Example

procedure DeleteCloneCustomerNon compliant code
As
BEGIN 
	DELETE CloneCustomer Where Name = 'Demo';
	COMMIT;
END DeleteCloneCustomer;

Compliant Code Example

procedure DeleteCloneCustomer(customerName In varchar2)Compliant code
As
BEGIN 
	DELETE CloneCustomer Where Name = customerName;
	COMMIT;
END DeleteCloneCustomer;
Visual Expert 2020
 VEPLSQLRULE77