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;