Hi,
I am working with APEX 20.
On a page I have a form region based on a query.
The primary key item of the form is defined as a select-list.
That item has the property Settings -> Page Action on Selection: Redirect and Set value.
So, when I select an item element from the list, all the fields of the form are filled with the corresponding record.
I want use the native APEX-form construct to delete a record.
For this purpose, the form region is defined with Attributes -> Edit -> Allowed Operations: Delete Row checked.
I also have a Delete button that is defined with:
Behavior -> Action: Submit Page, Database Action: SQL DELETE action.
If I press the button to delete a record, I get the following error:
---
Contact your application administrator. Details about this incident are available via debug id "37909".
Technical Info (only visible for developers)
is_internal_error: false
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 9195334635565502
component.name: Initialize form Update Forms
association_type: REGION
region_id: 9195238076565501
error_backtrace:
ORA-06512: at "APEX_200100.WWV_FLOW_FORM_REGION", line 2165
ORA-06512: at "APEX_200100.WWV_FLOW_FORM_REGION", line 2207
ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS_NATIVE", line 1245
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 2586
ORA-06512: at "APEX_200100.WWV_FLOW_PROCESS", line 203
---
Clicking few times on OK (when visualizing this error), the record is indeed deleted.
Does someone know what process is responsible for this error and how to get rid of it?
Kind Regards