Hello.
It seems that Code Hierarchy works wrong for "open cursor for select...".
As Example:
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:
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