hovering cursor over a cursor

[ScottMattes]

I ran into a strange thing. The code I was reviewing had a For Cursor loop and an assignment statement after the loop that used the %rowcount. Of course this isn't correct, but hovering the cursor over the cursor name gives as part of the hint 'rowcount = 0', even though at that point the cursor is closed. This also happens for an explicit cursor with OPEN/FETCH/CLOSE - hovering over the cursor after the CLOSE shows 'rowcount = 0'.

Shouldn't it say 'not a variable' at that point?

------------------
------------
Scott Mattes

 

[Marco Kalter]

It does indeed not seem logical that rowcount = 0. It is however the information that the Oracle Server returns for the cursor, so there's not much we can do about it.

------------------
Marco Kalter
Allround Automations