Here is the use case: 1) the page has some page elements that the user can modify; 2) the user can click on a save button to update those values; the values does not belong to one table only; 3) the save button is configured to trigger a dynamic action in the behaviour options and with confirmation; 4) the action triggered execute a PL/ SQL code that performs some validations before execute the updates on the necessary tables.
Is there a way to show the error message in line in the field when the PL/SQL code detects a validation issue? I've used
APEX_ERROR.ADD_ERROR (
p_message => 'Validation error',
p_display_location => APEX_ERROR.c_inline_with_field_and_notif,
p_page_item_name => 'P2_ABILITA_PROF'
);
here is the button settings:
here is the dynamic actions triggered by the button:
Infact the save (salva) button shows another button (change) and hides itself and a close button (typical edit mode buttons logic).
So the main question is: is it possible to have a reliable validation and error handling with a dynamic action button instead of a submit button? The page is complex with several elements placed in different areas (tabs) under an RDS, so it is important to save only the element of the current tab.