Bug: code completion shows :var4 etc. under special conditions

[Claus Pedersen]

Today, I have seen a variant of failing code completion, that I have never seen before. I have the code:

PROCEDURE tester IS
  CURSOR cur_emp IS
    SELECT emp.empno,
           emp.ename,
           emp.deptno -- department number
    FROM   emp empx
    ORDER BY emp.empno;
BEGIN
  FOR rec_emp IN cur_emp LOOP
    rec_emp.
  END LOOP;
END;

Code completion after "rec_emp." (line 10) shows the following list:

:var4                   varchar2
:var3                   varchar2
:var2--departmentnumber varchar2

Something is rotten ... :grin:

 

[Marco Kalter]

That is indeed not a very helpful list. We'll fix it.