Hi,
Using the great tutorial here: https://www.youtube.com/watch?v=4a9VxZjnT7E
I have setup a WEB API application running on a simple Department table (DepartmentId, DepartmentName).
I have also created a REST Data Source in APEX and added the PUT operation.
Then, I created a simple IG based on the REST Data Source.
Now, when I try to update (PUT) any of the values in the table, the method is actually executed (I can see the change in the underlying DB) but I also I get the following error:
ora_sqlerrm: ORA-20987: Error at line 1, col 1: expected [ or {
error_backtrace: ORA-06512: at "APEX_200200.WWV_FLOW_INTERACTIVE_GRID", line 8425
ORA-06512: at "APEX_200200.WWV_FLOW_INTERACTIVE_GRID", line 8448
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS_NATIVE", line 1140
ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2757
ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 203
component: APEX_APPLICATION_PAGE_PROCESS Department - Save Interactive Grid Data (17097396615592433)
Note when testing the PUT method from POSTMAN - everything seems to be OK.