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;