Jasper studio reports:How to call PL SQL function that returns cursor(Note: its NOT a procedure with out parameter that returns a cursor

[rafia.chanelize]

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!!!