G-3140
🆓Warning
Try to use anchored records as targets for your cursors.
Reason
Using cursor-anchored records as targets for your cursors results enables the possibility of changing the structure of the cursor without regard to the target structure.
Example
Non-Compliant Example
declare
cursor c_employees is
select employee_id,first_name,last_name
from employees;
l_employee_id employees.employee_id%type;
l_first_name employees.first_name%type;
l_last_name employees.last_name%type;
begin
open c_employees;
fetch c_employees into l_employee_id,l_first_name,l_last_name;
<<process_employees>>
while c_employees%found
loop
-- do something with the data
fetch c_employees into l_employee_id,l_first_name,l_last_name;
end loop process_employees;
close c_employees;
end;
/Issues
| Line | Column | Message |
|---|---|---|
| 10 | 22 | Use anchored record as target for cursor c_employees. |
| 15 | 25 | Use anchored record as target for cursor c_employees. |
Compliant Solution - ★★★★★
declare
cursor c_employees is
select employee_id,first_name,last_name
from employees;
r_employee c_employees%rowtype;
begin
open c_employees;
fetch c_employees into r_employee;
<<process_employees>>
while c_employees%found
loop
-- do something with the data
fetch c_employees into r_employee;
end loop process_employees;
close c_employees;
end;
/References
- same as Trivadis G-3140