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!

Migration path from APEX web service to ORDS

Olafur TJan 16 2018 — edited Feb 7 2018

Hi,

We have been using the web service part of APEX for a very long time and have built up quite a set of services there. Now with the 17.* versions and seeing all development happening over there (like REST-Enabled sql or OPEN API resource descriptions).

We are planning to migrate all our services to ORDS from APEX. Been googling, searched here and on Metalink but there doesn't seem to be any mention of any kind of formal migration process between these two environments. Having a hard time thinking that we are the only ones having to migrate. (All kind of services; home made systems, extensions on off-the-shelf systems,. OEBS, etc.)

I actually don't think it will be that hard or time consuming process to do. Simply create a script that gets the data from apex_rest_resource_handlers, apex_rest_resource_modules, apex_rest_resource_parameters and apex_rest_resource_templates and use the updated ORDS package to create them in the new environment.

But, knowing Oracle, I can't believe there isn't some (minor) SR Note that describes the "approved" process to do so. Or perhaps I'm missing some very obvious option in APEX that goes like "Migrate to ORDS".

17.4 documentation doesn't mention migration from APEX web services, APEX 5.1. doesn't mention how to migrate to ORDS.

So am I missing something or should I just use the apex_rest_resource* views to recreate them using ORDS?

Regards

This post has been answered by thatJeffSmith-Oracle on Jan 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2018
Added on Jan 16 2018
3 comments
816 views