Hi Oracle Gurus!
I need your help on strange behavior of ORDS:
1) I downloaded this demo machine with Oracle REST Data Services 18.3
https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
2) I have done 4 Labs included inside it:
Getting Started with Oracle REST Data Services series:
Installing and Administering Oracle REST Data Services (ORDS) with SQL Developer
AutoREST Enable Database Objects
REST Development
Insert, Update, and Delete Data using Restful Services
Here is direct link to a copy of these Labs outside the VM:
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/ords/r30/Insert_Update_Delete/Insert_Update_Delete.html
3) everything was working fine, including Get examples described in Lab 4 'Insert, Update, and Delete Data using Restful Services', until I came to 'Inserting Data Using RESTful Services' part.
I created POST Handler as described, ran WizTool REST client as described ... and got 500 Internal server Error
I checked APEX - it was working fine
I checked my GET urls - they were working fine
But no chance with POST.
Next day I asked my colleague to take the same demo machine image (he downloaded HIS OWN fresh COPY FROM https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html) and learn the LABs.
He returned to me at the same step - POST is not working!
Next day we tried to set up Oracle REST Data Services 18.3 in our development environment (oracle 12.1, apex 18.1).
and got the same trouble: GET is working, POST is not (various errors: 404, 403, 500, ...)
Please help how to troubleshoot this?
Is there a guide to debug this?
something like 'If ORDS returns ERRORS - check logs THERE, check this, that, ....'
Thanks in advance!