When Using a Web Service in APEX, Getting Errors ORA-01403 No Data Found or ORA-06512 at WWV_FLOW_CREDENTIAL
(Doc ID 2949806.1)
Last updated on MAY 17, 2023
Applies to:
APEX Application Development - Version NA and laterOracle Application Express (APEX) - Version All and later
Information in this document applies to any platform.
Symptoms
1.- You have a custom code in your APEX application which calls to an external Web Service using an API like apex_web_service.make_rest_request
2.- When running the APEX application page with the Web Service call, it fails with error ORA-01403: no data found
3.- When you review the Debug ID associated with the error, you see an output similar to:
Technical Info (only available for developers)
is_internal_error: false
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found
ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55
ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line126
ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654
ORA-06512: at "APEX_220200.WWV_FLOW_CREDENTIAL", line 116
ORA-06512: at "APEX_220200.WWV_FLOW_CREDENTIAL", line 107
ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 529
ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 612
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: <component_id>
component.name: <component_name>
error_backtrace:
ORA-06512: at "APEX_220200.WWV_FLOW_CREDENTIAL", line 116
ORA-06512: at "APEX_220200.WWV_FLOW_CREDENTIAL", line 107
ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 529
ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 612
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |