Skip to Main Content

DevOps, CI/CD and Automation

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!

ODE.NET 11.1.0.7.20 on 10g Database?!

669018Nov 27 2009 — edited Dec 7 2009
Hi,

I found in the system requirements of ODE.NET 11.1.0.7.20 that an Oracle Database 11g version 11.1.0.7 is needed. My question is: Is it possible to install ODE.NET 11.1.0.7.20 on an Oracle 10g Database?

Thanks in advance!

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 Jan 4 2010
Added on Nov 27 2009
2 comments
4,980 views