2 Replies Latest reply on May 9, 2016 10:17 PM by CarlosDLG

    results from SQL function stuffed into single column

    f53c6a20-e62f-4f52-bc99-1d04d284511c

      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.

      oneline.jpg

      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!