Code Hierarchy issue

Buzz_ss

Member²
Hello.

It seems that Code Hierarchy works wrong for "open cursor for select...".
As Example:

Code:
function test return sys_refcursor
is
 c_dual sys_refcursor;
begin
 open c_dual for
  select * from dual;
 return  c_dual;
end;

When cursor located on "select * from dual" last hierarhy item shows "statement". Clicking on this item selects next 2 lines:

Code:
open c_dual for
  select * from dual;

But I expect more deep hierarchy in this case. I need select only SQL text... as example for calling "test" or "plan".
Can You add Item "select" into Code Hierarchy for such situations?

Thanks
 
Back
Top