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

0

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

rafia.chanelize's picture
Joined: Oct 7 2017 - 1:44am
Last seen: 1 year 5 months ago

0 Answers:

No answers yet
Feedback