Nobody has any input here ?
It almost looks like i am on someone's blacklist :-)
No as i said in my opening post, i want it to display the cursor as a regular table.
Just as it would do when you would do: Display as Table with a sql query, such as select * from user_tables.
Now the only options with pl/sql are:
-pl/sql dbms code: the output can only be formatted as html. Displaying cursor output can only be done tru html tables which has other undesired effects.
-Table option: as i said before this displays the output of the cursor in one row as text. Ofcourse not the desired result.
-Code: as stated before: this seems to fetch the cursor and print the contents together with header info etc. for every 10 rows(or so). Also because it is printed as text it displays columns with wide varchar declaration in its full width.
All not desired, iw ould like to see the output in Table style, allowing the option to export the data.
No idea about refcursor in report, but do you really need it? If you know column configuration you'll get, you can always return pl/sql table instead, and then do select * from table(your_function).
My problem is i don't know which and how many columns i get returned.
( I have package that generates sql queries )
It is not that difficult to encapsulate the returned dbms output(ready to run qry as plain text) and run it and return it as a refcursor.
But what columns and which varies in my case.
Since i noticed that it already, sort-of, handles a refcursor, i was hoping sqldevloper could handle a refcursor and just iterate it and display it as a table.