Skip to Main Content

E-Business Suite

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!

jan Opening balance for

User_T4ACLMar 9 2020 — edited Feb 9 2021

hello

i have account 12310006 was defined as expenses but it's liability, the problem here that opening balance of jan-20 is 0 not the ending of dec-19 , i modified the account to asset but it couldn't help

is there any way to solve this and modify account balance

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

Post Details

Added on Mar 9 2020
2 comments
74 views