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!

Saving Report Columns into a Collection

ShuvamMar 28 2017 — edited Mar 29 2017

Hi everyone,

I have a requirement to create an application which will allow multiple users to move around of the wizard in any way they want to.Let's say, entering different quantities for multiple products,by multiple users.

In Apex 5.0.4 , I did it by creating a tabular form based on apex_collection sql query ,making the required fields editable and used apex collection.update_member_attribute to update the collection.

But in Apex 5.1, I am not able to acheive the same functionality using interactive grid.

The list of issues that I am currently facing are

1. In the attribute property tab when I am making some change in the properties section

Edit-->Enabled--> Yes,

Allowed Operations--> Update Row

all the columns are getting editable. As per requirement I want only a particular column say, quantity column to be editable.

2. Fields are not getting updated when the below mentioned query is invoked.Is there any issue with wwv_flow.g_f01 in apex 5.1? The below piece of code worked properly in apex 5.0.4.

apex_collection.update_member_attribute (p_collection_name=> 'product_collection',p_seq=> c1.seq_id,p_attr_number =>9,p_attr_value=>wwv_flow.g_f03(c))

Can somebody please help me on this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2017
Added on Mar 28 2017
2 comments
449 views