Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting ORA-01403:no data found

edited Jun 23, 2021 6:40AM in Autonomous Database

Content

Hi Team

I am trying to use flows for apex with my current apex application . I have created a simple flow with Approval Hierarchy with an User task to create a program . every time i create a program a new instance is created in flows for apex (Working fine) ,But when i try to update the same data it gives me an NO DATA FOUND error.

  • is_internal_error: false

  • ora_sqlcode: 100

  • ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2301 ORA-06512: at line 73 ORA-06512: at line 147 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 679 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 2262 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_200200.WWV_FLOW_CODE_EXEC", line 340 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 1694 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2781

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!