Hi,
I have a simple master - detail data entry form created in apex 4.2.6 master-detail wizard. While deleting a record from detail region, I am getting below error -
1 error has occurred
- ORA-01403: no data found (Row 5)
If I look at debug log it shows -
4 | |
0 | ...Execute Statement: begin wwv_flow.g_boolean := :request like ('SAVE') or :request like 'GET_NEXT%' or :request like 'GET_PREV%'; end; |
0 | ......Result = false |
0 | ......Skip because condition or authorization evaluates to FALSE |
0.016 | ...Process "ApplyMRD" - Type: MULTI_ROW_DELETE |
0 | Add error onto error stack |
0 | ...Error data: |
0 | ......message: ORA-01403: no data found |
0 | ......additional_info: ORA-01403: no data found |
0 | ......display_location: INLINE_IN_NOTIFICATION |
0 | ......association_type: REGION |
0 | ......region_id: 12187514465108621 |
0 | ......row_num: 5 |
0 | ......is_internal_error: false |
0 | ......ora_sqlcode: 100 |
0 | ......ora_sqlerrm: ORA-01403: no data found |
0 | ......error_backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ITEM", line 3479 |
0 | ......component.type: APEX_APPLICATION_PAGE_PROCESS |
0 | ......component.id: 12193301463108691 |
0 | ......component.name: ApplyMRD |
0 | Show current page with inline errors |
0 | S H O W: application="140" page="48" workspace="" request="" session="34287691918266" |
0 | Reset NLS settings |
Can you please help me to know what's going wrong here..... If I delete from sql command prompt, it works fine. Thanks.
-Anand