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.

Oracle APEX - Loop through an Interactive Grid/Interactive Report and do PL/SQL processing

BhavFeb 14 2025

Hello APEX Experts,

We are migrating the legacy Oracle Forms pages into the Oracle APEX pages.

On one of the page, we have an Interactive Grid with 3 columns: Role_Name (Display Only), Role_Description (Display Only) and Enabled (Checkbox).

On click (or on change) of a checkbox we would like to do some sort of PL/SQL checking and dynamically ticked/unticked the Enabled column. For this we have to go through (loop through) the existing available roles and have to check against each role.

We are stuck here, we don't know how can we check the current value of the role_name with other available role_name in a grid? How to implement this? Is the IG correct solution for this? Is there alternative solution available (say using IR)?

Your help and support would be appreciated.

We are using APEX v23.2.

My APEX IG:

I have also attached the sample code: WHEN-CHECKBOX-CHANGED for your reference. It fires when checkbox changed.

sample_code.txt

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Feb 14 2025
5 comments
122 views