选项1创建函数以返回强引用游标。
create or replace function getCursor return refcur_pkg.refcur_t is
c_tmp refcur_pkg.refcur_t;
begin
open c_tmp for select * from StockTable;
return c_tmp;
end;
SELECT * FROM TABLE(StockPivot(getCursor()));
选项2。您可以尝试使用游标表达,它也应该起作用。光标表达。
SELECT * FROM TABLE(StockPivot(Cursor(select * from StockTable)));