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 use Identity columns with an IG column?

Eslam_ElbyalyJul 3 2022

Hi. I am using Oracle APEX 22.1.1.
I have an IG with a hidden PK column based on an identity column(generated always). When I try to save a new record, I get "cannot insert into a generated always identity column" error. I changed it to "DEFAULT" instead of "generated always", and it showed "can not insert null into column_name" error. It only worked with "DEFAULT on null". Is there a problem using the other two options "generated always" and "DEFAULT"?

This post has been answered by Carsten Czarski-Oracle on Jul 5 2022

Jump to Answer

Added on Jul 3 2022

#apex-discussions

3 comments

1,383 views

1 mention