Jasper studio reports:How to call PL SQL function that returns cursor(Note: its NOT a procedure with out parameter that returns a cursor
i tried it in 2 ways
first one:
select * FROM TABLE (fs_sorter_error_r.sorter_cntr_error('W6','03-MAY-2017',' 03-MAY-2017','967',20001))
that return s ERROR "cannot access rows from non nested tables "
Second one:
select fs_sorter_error_r.sorter_cntr_error('W6','03-MAY-2017',' 03-MAY-2017','967',20001)t1 from dual
which executes without error but returns one field t1 as oracleresultset which does not display anything.
Am struggling !!!! plz let me see some karma!!!
0 Answers:
No answers yet