'Change values in specific rows

I have a list of notifications: enter image description here

The column that is called 'Close' is actually called Is_Read and is by default 0. I would like to achieve that when I click the X button the value changes to Is_Read=1 and will disappear from the list.

I already configured a dynamic action

enter image description here

And if true then it executes Server side code PL/SQL:

Update Notification_party set Is_Read=1 where Notification_ID = :Notification_ID and Party_ID = :P_36_USER;

However nothing happens even when I refesh the page. I think the problem is that when I press the X (which is a link) it does not know which row I am using.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source