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!

How to update a database column from an Interactive Grid in Oracle APEX (20.2)

952351Mar 8 2023

I am modifying and updating an existing Oracle APEX application (running APEX 20.2) and one of the forms contains an Interactive Grid that displays database user account information (ie..username, password, etc). This IG is used to retrieve AND update the passwords that DBA's need to use on a daily basis however the password field is not editable so we are not able to update the password(s).

Here is what I've attempted…..at the DB Report non-export control region I have tried changing the Edit attribute from Enabled Off to Enabled On (as seen in the screen print below). I couldn't find anything at the column level (password) in the property editor to make this specific field editable.

It appears this should be an easy fix to just be able to update a database column with an updated value but I'm not seeing it. The fact that it's an IG type shouldn't be the issue should it?

Any help/suggestions would be appreciated.

Thanks,

Jeff

This post has been answered by 952351 on Mar 9 2023
Jump to Answer
Comments
Post Details
Added on Mar 8 2023
4 comments
95 views