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!

Adding few new columns to already existing interactive grid(enabled editing) doesn't allow to insert a new row in UI page

Pomalini RMar 22 2024

I have an interactive grid for a table which is enabled to edit and the table has 3 columns, one of the columns is ID column which is primary key where I have used trigger to populate the sequences, in this table I have recently added 2 new columns in the IG source - SQL query, after this addition I can run the page and can see the newly added columns but when I click Add a row in IG and try to insert a record into the table the primary key column is throwing error as cannot insert null into ID column, even though my trigger is present.

Here my question is before this new addition of column the IG was working fine and allowing me to insert a row in the table but after the change it is not working as expected, what could be the reason and what are the work around I have to follow to resolve this error.

Note: I am using Oracle Apex 23.2.4 version.

Comments
Post Details
Added on Mar 22 2024
1 comment
362 views