Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to solve this error of Oracle apex rest data sources- 1403-no data found
User_LNIFK
Rank 1 - Community Starter
uploading file into object storage from apex , rest data sources, it fails with error ORA-01403: no data found
error
Technical Info (only available for developers)
- is_internal_error: false
- ora_sqlcode: 100
- ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643 ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 116 ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 107 ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 542 ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 581 ORA-06512: at line 45 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 430 ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC_LOCAL", line 3101 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2657 ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2693 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1265 ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3443
- component.type: APEX_APPLICATION_PAGE_PROCESS
- component.id: 18117745065627247
- component.name: UploadToOCI
- error_backtrace:
- ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 116
- ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 107
- ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 542
- ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 581
- ORA-06512: at line 45
- ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
- ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806
- ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603
- ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 55
- ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 126
- ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2643
- ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 116
- ORA-06512: at "APEX_230100.WWV_FLOW_CREDENTIAL", line 107
- ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 542
- ORA-06512: at "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 581
- ORA-06512: at line 45
- ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
- ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 806
- ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2603
- ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 97
- ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC_PLSQL", line 430
- ORA-06512: at "APEX_230100.WWV_FLOW_CODE_EXEC", line 614
- ORA-06512: at "APEX_230100.WWV_FLOW_EXEC_LOCAL", line 3101
- ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2657
- ORA-06512: at "APEX_230100.WWV_FLOW_EXEC", line 2693
- ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 34
- ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1265
- ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3443
- ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS", line 189
- error_statement:
- begin declare
- l_request_url varchar2(32767);
- l_content_length number;
- l_response clob;
- upload_failed_exception exception;
- l_request_object blob;
- l_request_filename varchar2(500);
- begin
- select blob_content,filename into l_request_object,l_request_filename from apex_application_temp_files
- where name = :P13_FILES;
- l_request_url := :G_BASE_URL||'/b/'||:P13_BUCKET_NAME||'/o/'||apex_util.url_encode(l_request_filename);
- l_response := apex_web_service.make_rest_request(
- p_url => l_request_url,
- p_http_method => 'PUT',
- p_body_blob => l_request_object,
- p_credential_static_id => 'OCI_SA'
- );
- end;
- end;
0