Hello.
It seems that Code Hierarchy works wrong for "open cursor for select...".
As Example:
When cursor located on "select * from dual" last hierarhy item shows "statement". Clicking on this item selects next 2 lines:
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
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