Skip to Main Content

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!

"ORA-20987: Error at line 1, col 1: expected [ or {" -> when using REST Data Source in IG

User_LM318Mar 14 2021

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.

Comments

Processing

Post Details

Added on Mar 14 2021
1 comment
1,396 views