CODEWITHSUNDEEP
oracle-databaseoracle-apex
Ali
Ali

Reputation: 11

ORACLE APEX Question on using Update / Save Button

I've created an APEX page based on a single table, which is then called by a another APEX page with a field value to be queried. The page displays the record, which has a Primary Key consisting of 2 fields. When I use the Update/Save button, it appears not to update the data, though it does not return any errors. This works OK on other APEX pages where they are based on Tables with a single field Primary Key.

I would appreciate an explanation/solution from anyone who has had a similar problem and found a workaround.

Thanks in advance

Upvotes: 1

Views: 3864

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

Your page should have a "Process Row of MYTABLE" process. Have a look in the details of the process, you'll find that it has the following attributes:

  • Item Containing Primary Key Column Value
  • Primary Key Column
  • Item Containing Secondary Key Column Value
  • Secondary Key Column

Your process should include both Primary and Secondary Keys.

Upvotes: 1

Related Questions