There are a few things about the following procedure that PL/SQL Developer doesn't handle, even though I'd like it to 
Code:
01 CREATE OR REPLACE PROCEDURE MyTestProcedure IS
02
03 CURSOR myCursor
04 IS
05 SELECT 'a' AS one,
06 'b' AS two
07 FROM DUAL;
08
09 myRecord myCursor%ROWTYPE;
10
11 TYPE myArrayOfRecordsType IS TABLE OF myCursor%ROWTYPE INDEX BY BINARY_INTEGER;
12
13 myArrayOfRecords myArrayOfRecordsType;
14
15 BEGIN
16
17 OPEN myCursor;
18 FETCH myCursor BULK COLLECT INTO myArrayOfRecords;
19 CLOSE myCursor;
20
21 FOR i IN myArrayOfRecords.FIRST .. myArrayOfRecords.LAST LOOP
22
23 myRecord := myArrayOfRecords(i);
24
25 DBMS_OUTPUT.put_line(myRecord.one);
26 DBMS_OUTPUT.put_line(myArrayOfRecords(i).two);
27
28 END LOOP;
29
30 END;- The Code Assistant pops up for myRecord (line 25), but not for myArrayOfRecords(i) (line 26).
- No tooltip appears when hovering over i. Changing the variable name to something longer (e.g: idx) fixes this.
- When hovering over myRecord.one (line 25) its value is shown, but for myArrayOfRecords(i).two (line 26) the tooltip shows the value of i, even when hovering over the two.
- When hovering over myArrayOfRecords, a tooltip appears and "View collection variable" works (and gives an error in this case). Not so for myArrayOfRecords( (lines 23 and 26). There, no tooltip appears and "View collection variable" does nothing (no error). The same thing happens with a collection of scalars.
- There is no "View record variable". The only way to view record contents is one member at a time.
- If "View record variable" is ever implemented, support for collections of records would be nice.
