Code assistent: For Loop variable

[Patrick Wolf]

Hi,

it seems that the code assistant doesn't recognize FOR LOOP variables.

eg.

FOR rTest IN (SELECT 1 AS A, 2 AS B FROM DUAL)
LOOP
    DBMS_Output.put_line('test: '||rTest.A);
END LOOP;

1) When I write the DBMS_Output statement and enter rT autocomple doesn't show rTest.
2) If you click afterwards on rTest it doesn't highlight all occurences of rTest as it normally does for other variables.
3) Refactor item also doesn't work

Regards
Patrick

 

[Marco Kalter]

it seems that the code assistant doesn't recognize FOR LOOP variables.

Works okay for me. Which PL/SQL Developer version are you using?

1) When I write the DBMS_Output statement and enter rT autocomple doesn't show rTest.
2) If you click afterwards on rTest it doesn't highlight all occurences of rTest as it normally does for other variables.
3) Refactor item also doesn't work

For implicit variables these functions do indeed not work. I have added this to the list of enhancement requests.

 

[Patrick Wolf]

Works okay for me. Which PL/SQL Developer version are you using?

My version is 7.0.3.1110 beta

What does exactly work for you?

 

[Marco Kalter]

What does exactly work for you?

The Code Assistant works okay when describing the rTest variable. I see now that this is not what you were inquiring about, just the 3 issues you mentioned.