Just trying to get my query results of a function into normal grid format in SQL Developer to start.

Then please mark the thread ANSWERED and repost it in the Sql Dev forum.

SQL Developer

f53c6a20-e62f-4f52-bc99-1d04d284511c wrote:

 

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:

RETURN sys_refcursor
AS o_cursor SYS_REFCURSOR;
Begin
open o_cursor for

select……………
Return o_cursor;
End;
/

How do I get the output formatted in normal grid format?

Thanks!

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