Hello,
I do have a problem that there is a procedure that return a SQL cursor from a complicated Select. I need to sum first column data grouped by second column data. Procedure output is used by others so there is limited possibility to change it.
I tried to bulk load cursor into table type, but I was unable to either load the data (cursor is sys_ref and table type global) or unable to manipulate table type by select (defined local cursor type and local table type).
I think that it is possible to load row by row via loop. But maybe there is some other better way?
M