Home
Variables Declared multiple times in nested scope
Rule description
- Variables should be declared only once in a scope
Non-compliant Code Example
DECLARE
CURSOR curs_customer(customer_name VARCHAR2) RETURN customer%ROWTYPE; --Non compliant code (Variable declare more than one time)
CURSOR curs_customer(customer_name VARCHAR2) RETURN customer%ROWTYPE IS SELECT * FROM CUSTOMERS WHERE name = customer_name;
BEGIN
NULL;
END;
Compliant Code Example
DECLARE
CURSOR curs_customer1(customer_name VARCHAR2) RETURN customer%ROWTYPE; --Compliant code (Variable declare once)
CURSOR curs_customer2(customer_name VARCHAR2) RETURN customer%ROWTYPE IS SELECT * FROM CUSTOMERS WHERE name = customer_name;
BEGIN
NULL;
END;