Skip to Main Content

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Interactive grid dynamic sum in a total row

Ace1Feb 14 2022

I am struggle with a dynamic sum in my IG. I created items which sum up values in columns dynamically but it is not looking too good. When users zoom out the screen, items stretch too much. I tried to fix it with the column span attribute but it didn't work. Is it possible to place items inside the IG? Or maybe add to the IG code union all with values of items and refresh only one row when users change values in the IG?

This post has been answered by Hamza Al-abbasi on Feb 14 2022
Jump to Answer

Comments

Kalpataru

Hi Soofi,

Is your source database and destination database version are same , check the both database version properly ?

Is your view have rowid column ?

If yes then remove the rowid column and try.

You can also check this threads for your reference.

http://www.orafaq.com/forum/t/119514/

ORA-02070: database TO_LINK does not support operator USERENV in this cont

SQL Error: ORA-02070: database does not support in this context

If your issue is not resolved then you can ask it in Oracle Support Forms forum for better help.

Andreas Weiden
Answer

If oyu use a "foreign" database other than Oracle, the concept of ROWID's is unknown.

You can overcome this by changing the Key-Mode of the block to "Non-Updateable" and mark your PK-column-item in the block by Setting the property "Primary Key" to "Yes"

Marked as Answer by Soofi · Sep 27 2020
Soofi

Thanks Andreas Weiden,

It worked for me. But what if my foreign table has no primary key.

Regards,

Soofi

Andreas Weiden

But what if my foreign table has no primary key.

Well, then you are out of luck (and you have a problem with the database-design).

1 - 4

Post Details

Added on Feb 14 2022
18 comments
5,843 views