Just trying to get my query results of a function into normal grid format in SQL Developer to start.
However, my output is stuffed into a single column when I run it from a select() from dual. Even though the output variables window shows output formatted just fine in grid format.
I’m running a function like this:
SELECT function_with_sql(sysdate) from dual;
The function has a cursor defined like this:
AS o_cursor SYS_REFCURSOR;
open o_cursor for
How do I get the output formatted in normal grid format?
Your function returns a ref cursor. You cannot do that with a ref cursor. Why would you want to do that?
You probably don't understand ref cursors. Here is a recommended read: PL/SQL 101 : Understanding Ref Cursors