Skip to Main Content
Forums

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!

Problem in PL/SQL = Error Stack: ORA-01403: No Data

Jan RunhartJul 31 2020

I've created an upload system with web services (uploading to Oracle bucket). I've copied the pages and webservices to my new app but i'm having problems with the uploading function. The error i'm getting is ORA-01403: No Data, in the original page there is no problem and everything is working. Can someone please help me with this problem or send me in the good direction.

PL/SQL code

begin declare  
  l_request_url varchar2(32767);  
  l_content_length number;  
  l_response clob;  
  upload_failed_exception exception;  
begin  
  for file in (  
  select * from apex_application_temp_files  
  where name = :P101_FILE  
  ) loop  
  l_request_url := :G_BASE_URL || 'b/##BUCKETNAME##'  
  || '/o/' || apex_util.url_encode(file.filename);  
  
  apex_debug.info('File: %s', file.filename);  
  apex_debug.info('URL: %s', l_request_url);  
  apex_debug.info('Mime: %s', file.mime_type);  
  
  apex_web_service.g_request_headers(1).name :=  
  'Content-Type';  
  apex_web_service.g_request_headers(1).value :=  
  file.mime_type;  
  l_response := apex_web_service.make_rest_request(  
  p_url => l_request_url  
  , p_http_method => 'PUT'  
  , p_body_blob => file.blob_content  
  , p_credential_static_id => :G_OCI_WEB_CREDENTIAL  
  );  
  if apex_web_service.g_status_code != 200 then  
  raise upload_failed_exception;  
  end if;  
  end loop;  
end;
end;

P101_FILE = a upload file item

##BUCKETNAME## = inthe original code is the actual name of the bucket.

Debug:

Exception in "plsql process":
Error Stack: ORA-01403: Geen gegevens gevonden.
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1594
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2658
ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1568
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC_LOCAL", regel 2761
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3775
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3810
Backtrace: ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1594
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2658
ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1568
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC_LOCAL", regel 2761
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3775
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3810
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 76
2
1%
0.04179 0.00030
Exception in "uploadFile":
Error Stack: ORA-01403: Geen gegevens gevonden.
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 96
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1594
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2658
ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1568
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC_LOCAL", regel 2761
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3775
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3810
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 76
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 1156
ORA-06512: in "APEX_200100~
Backtrace: ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 96
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1594
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2658
ORA-06512: in "APEX_200100.WWV_FLOW_CREDENTIAL", regel 106
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 376
ORA-06512: in "APEX_200100.WWV_FLOW_WEBSERVICES_API", regel 416
ORA-06512: in regel 22
ORA-06512: in regel 22
ORA-06512: in "SYS.DBMS_SYS_SQL", regel 2120
ORA-06512: in "SYS.WWV_DBMS_SQL_APEX_200100", regel 590
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 2621
ORA-06512: in "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", regel 1568
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC_LOCAL", regel 2761
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3775
ORA-06512: in "APEX_200100.WWV_FLOW_EXEC", regel 3810
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 76
ORA-06512: in "APEX_200100.WWV_FLOW_PROCESS_NATIVE", regel 1156
ORA-06512: in "APEX_200100.WWV_FLOW_PLUGIN", regel 2586
ORA-0~
2
1%
0.04209 0.00065
Add error onto error stack
4
1%
0.04273 0.00020
Hiding error additional_info, as it contains ORA error message: ORA-01403: Geen gegevens gevonden.
1
0%
0.04293 0.00002
Error: ORA-01403: Geen gegevens gevonden

.
Comments
Post Details
Added on Jul 31 2020
#apex-discussions
0 comments
637 views