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!

Why is the generation of a Primary Key value not automated when not using rowid in an Interactive Gr

KevinFitzJun 19 2017 — edited Aug 7 2017

Hi,

I've created an editable Interactive Grid using the Page wizard where Source is based on a Table and Primary Key column is ROWID. On testing the Page, I am able to Add Rows into the database table without adding any functionality to the Page created by the wizard. However, when I do the same thing but choose Primary Key column as the primary key of the target table then Add Rows will fail as the primary key column is being given a Null value. Can anybody tell me what is happening in the background to explain this 'discrepancy' between the 2 choices and what I would need to add to the page to get it to work in the second scenario ( i.e. not using ROWID as the Primary Key column ).  In the past, I was able to create a pl/sql process to put the PK value into the hidden PK item

SELECT MAX( <pk_column_name> ) + 1

   INTO <page_item_name>

  FROM <table_name>

but this no longer solves the issue.

regards,

Kevin.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2017
Added on Jun 19 2017
9 comments
995 views