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!
After creating my graph user and granting permissions I don't have Graph Studio as an option under Tools for my ATP database? Created an ADW and same issue exists. How to I enable Graph Studio for my Autonomous database?
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.
f53c6a20-e62f-4f52-bc99-1d04d284511c wrote:
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: