PlSql Developer does not popup values via Code Assistant in next example:
The Code Assistant pops up for l_rec. (line 12), but not for l_tab(1). (line 13)
PL/SQL Developer Version 8.0.3.1510
Code:
1 CREATE OR REPLACE PROCEDURE MTest IS
2 TYPE rec_type IS RECORD(
3 n1 NUMBER,
4 n2 NUMBER);
5 TYPE tab_type IS TABLE OF rec_type;
6
7 l_rec rec_type;
8 l_tab tab_type;
9 BEGIN
10 SELECT 1,1 BULK COLLECT INTO l_tab FROM dual;
11 SELECT 1,1 INTO l_rec FROM dual;
12 dbms_output.put_line(l_rec.n1);
13 dbms_output.put_line(l_tab(1).n1);
14 END;
The Code Assistant pops up for l_rec. (line 12), but not for l_tab(1). (line 13)
PL/SQL Developer Version 8.0.3.1510