Toad World® Forums

Rule 2131: Use CONSTANT wrong for CURSOR declaration

Cursors cannot be declared as CONSTANT:

image


Example:

DECLARE
  cur1 SYS_REFCURSOR;

  TYPE t_cur IS REF CURSOR RETURN dual%ROWTYPE;
  cur2 t_cur;
BEGIN
  OPEN cur1 FOR SELECT * FROM dual;
  CLOSE cur1;

  OPEN cur2 FOR SELECT * FROM dual;
  CLOSE cur2;
END;

Thanks Peter.
Changing the list in line 2 of the expression to (ASSIGN/LHS, INTO_LIST, PARAM, OPEN, CLOSE, FETCH) should work.
I'll change that here as well. (QP-3901)

Thanks,
Andre