More Solutions

Products Banner

How to solve this error of Oracle apex rest data sources- 1403-no data found

Question
91
Views
0
Comments

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;