G-2610

🆓

Warning

Never use self-defined weak ref cursor types.

Rule Details

Severity Level: Minor
Quality Area: Maintainability
Fixing times: 5 mins
Local-medium
Database Support: OracleDB (v7.3.4 +)

Reason

There is no reason to define your own weak ref cursor types, as they are not different from the built-in sys_refcursor. Introducing your own types just gives you unnecessary maintenance to perform.

Example

Non-Compliant Example

declare
   type local_weak_cursor_type is ref cursor;
   c_data local_weak_cursor_type;
begin
   if configuration.use_employee then
      open c_data for
         select e.employee_id,e.first_name,e.last_name
           from employees e;
   else
      open c_data for
         select e.emp_id,e.name
           from emp e;
   end if;
end;
/

Issues

Line	Column	Message
2	32	Use sys_refcursor instead of self-defined weak ref cursor.

Compliant Solution - ★★★★★

declare
   c_data sys_refcursor;
begin
   if configuration.use_employee then
      open c_data for
         select e.employee_id,e.first_name,e.last_name
           from employees e;
   else
      open c_data for
         select e.emp_id,e.name
           from emp e;
   end if;
end;
/

References

same as plsql:WeakRefCursorCheck
same as Trivadis G-2610