Currently, PL/SQL editor provides no completion insight for rowtype variables, including implicit ones, used in cursors.
create or replace procedure test_rowtype as
v_bonus bonus%rowtype;
cursor cur_bonus is
select ename, job, sal from bonus;
begin
--v_bonus. should show column autocomplete list!
for b in cur_bonus loop
null;
-- b. should also show similar list!
end loop;
end test_rowtype;
I can understand that's probably difficult to implement from technical standpoint (in-depth code analysis etc), but I'm pretty sure stuff like breadcrumbs and outlines already uses said code analysis. Having autocomplete for such variables would greatly simplify my workflow. Are there any plans to implement it, or maybe it's supposed to be working already and just bugged for me?
Also, %rowtype is not recognized as a keyword by the formatter. That's not causing any problems, but should still be fixed, IMO.