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!

Interactive Grid ROW_ID

HampOct 6 2019 — edited Nov 9 2019

Hello ,

I have an IG with the primary key (ROW_ID) hidden. this column in database layer has a sequence and trigger attached to it. now, i have set this column as hidden in my IG. when I add a new row and try to save it, i receive

Ajax call returned server error ORA-20987: APEX - ORA-01400: cannot insert NULL into ("SIN"."A_table_S"."ROW_ID") for .

I know in V5.1 you can't change hidden column but i wanted to know if there is anyway that null can be passed to the table and the trigger on the table insert the row_id.

btw i tried to set the default(SEQ.NEXTVAL) on the ROW_ID that also didn't work.

any idea what i can do?

thanks

Hamp

This post has been answered by Franck N on Oct 7 2019

Jump to Answer

Added on Oct 6 2019

#apex-5-1, #apex-discussions

3 comments

2,344 views