Skip to Main Content

ORDS, SODA & JSON in the Database


For appeals, questions and feedback about Oracle Forums, please email Please ask technical questions in the appropriate category. Thank you!

APEX webservice visibility vs ORDS

Scott WesleySep 17 2015 — edited Sep 30 2015


We've upgrade to APEX 5.0.1 and ORDS 3.0 (not sure if 3.0.1), and we have working webservices using ORDS, but they are not shown in SQL Workshop, nor do APP_IMAGES get rendered.

I'm a little sketchy on the details as I did not set this up and my colleague is not at hand, but I'll do best to provide some facts that I'm sure will highlight some simple setting that needs adjusting.

My colleague had web service issues with our existing workspace so he tried creating another, and in the second new workspace it's all working correctly.

ie - I can see services listed in the workshop and images from the repository are rendered correctly using #APP_IMAGES#my_image.png.

For instance, in the new workspace the path resolves as

<img src="125117155154685/r/103/files/static/v2/button_colours.png">

in the workspace that doesn't work it is

<img src="our_workspace_name/r/101/files/static/v2Y/button_colours.png">

and the browser complains it couldn't GET the file.

Selecting from apex_050000.WWV_FLOW_RT$MODULES returns three older records we tested with a while ago, that I see listed in the workshop only in the new workspace.

ORDS_METADATA.ORDS_MODULES shows three different modules, created by my colleage, not seen in either workspace in SQL workshop. But these are active modules managed by my colleague in SQL Developer (I think).

Users APEX_LISTENER and APEX_REST_PUBLIC_USER exist and are unlocked.

I've been using Dietmar's kscope session to try get my head around it, and it seems slide 13 relates to our problem.

Any suggestions on things to check/tweak?


This post has been answered by Dietmar Aust on Sep 28 2015
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2015
Added on Sep 17 2015