Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Is ORDS requirement for trailing slash a Bug?

peter_raganitschJan 19 2018 — edited Jan 24 2018

Just found this "new" behavior while upgrading an old instance from ORDS 2.10 to 17.4.1.

Suddenly some REST webservices defined via APEX SQL Workshop didn't work anymore. They produced a 404 not found message: The procedure named ragtest could not be accessed, it may not be declared or the user executing this request may not have been granted execute privilege on the procedure. Check the spelling of the procedure and check that the execute privilege has been granted to the caller

Screen Shot 2018-01-19 at 11.50.18.png

Turns out, the URI template didn't have a trailing slash.

Screen Shot 2018-01-19 at 11.56.35.png

Under ORDS 2.x this wasn't required, somewhere in 3.x it must have started to need that, since I could reproduce that behavior also on apex.oracle.com which runs ORDS 3.10

Screen Shot 2018-01-19 at 11.25.39.png

Screen Shot 2018-01-19 at 12.03.12.png

Once the trailing slash is added, the webservice works fine again.

To me it feels like a bug, what do you think?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2018
Added on Jan 19 2018
11 comments
1,608 views