Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ......error_backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_ITEM", line

anand_gpMay 14 2018 — edited May 14 2018

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
...Process "ApplyMRU" - Type: MULTI_ROW_UPDATE
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
0Add 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
0Show current page with inline errors
0S H O W: application="140" page="48" workspace="" request="" session="34287691918266"
0Reset 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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2018
Added on May 14 2018
8 comments
624 views