Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

results from SQL function stuffed into single column

f53c6a20-e62f-4f52-bc99-1d04d284511cMay 9 2016 — edited May 9 2016

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!

This post has been answered by CarlosDLG on May 9 2016
Jump to Answer

Comments

unknown-7404
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.

CarlosDLG
Answer

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.

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!

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:

Marked as Answer by f53c6a20-e62f-4f52-bc99-1d04d284511c · Sep 27 2020
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 6 2016
Added on May 9 2016
2 comments
1,428 views