Skip to Main Content

Analytics Software

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!

DRM and Foundation and CSS Bridge

User_CDRSZJan 27 2021

Hi Everyone,
We have Foundation Services on Server 1 and Server 2 and DRM on Server 3 and Server 4. If we want to enable external authentication, do we need to Install CSS Bridge on Servers 1 and 2? That is what I am gathering from the DRM Installation guide. Can someone please confirm if this is the case?
Thanks.

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