Home

Rule description

• Procedures should have parameters

Non-compliant Code Example

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

Compliant Code Example

procedure DeleteCloneCustomer(customerName In varchar2)
As
BEGIN 
	DELETE CloneCustomer Where Name = customerName;
	COMMIT;
END DeleteCloneCustomer;