Hi,
My environment :
APEX Version 24.1.6
ORDS Version 24.3.1.r3061450 ( for Rest Data Source and APEX )
Database Version : 19.22.0.0.0
I have defined a Rest Data Source on an a application .
I have created 5 operations : 2 get operations ( one “Fetch rows” and one “Fetch single row” ) , 1 POST for create, one DELETE for delete and one PUT for Update in order to use them in an interactive grid.
I have a test button ( Test operation ) for the “Fetch Rows” Get Operation. When I click on this button , I have a message “ORA-01403: no data found”.
If I update the “Fetch Single Row” Get Operation and set Database Action to “Not Mapped” then , the Test Operation is working and I can see all the datas of my Rest Data Source.
When I create the Interactive grid based on this REST Data Source , I have the same behaviour when displaying the grid.
The debug trace shows ( Liste is the name of ny Interactive Grid ):
Exception in "Liste ": Error Stack: ORA-01403: no data found
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2546
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2461
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_API", line 47
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_API", line 2120
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC_UTILS", line 394
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 2367
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 5035
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2449
Backtrace: ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2546
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2461
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_API", line 47
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_API", line 2120
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC_UTILS", line 394
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 2367
ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 5035
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2449
ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_WEB_SRC", line 2838
But it seems I need the “Fetch single row” for the “create” process with “Post” Operation .
What is wrong with my Rest Data Source ?