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!

ORDS Installation Advice - CDB vs. PDB, w/ or w/out APEX

user640987Jun 10 2022

I have a 19c database with 3 PDBs (DEV, TEST and DEMO) that support an ongoing research project that will span the next 2-3 years. I have decided to start experimenting with ORDS in order to expose PL/SQL stored procedures as REST-enabled APIs to various proof-of-concept web applications. Note that these web applications also follow the DEV, TEST and DEMO model.
I am new to ORDS, so after reviewing the documentation, my first instinct is to install ORDS at the PDB-level (not the CDB) for flexibility and not to install APEX as I simply do not have the need for APEX at this time (although it might be interesting to experiment with at a later date).
Given that ORDS traces its origins back to APEX, I am curious if my installation plan is sound or if I should consider installing ORDS at the CDB level or if I should install APEX. Thank you in advance for sharing your thoughts/experiences/opinions.

This post has been answered by thatJeffSmith-Oracle on Jun 10 2022
Jump to Answer

Comments

Timo Hahn

User, you are posting in the wrong space. Your question has nothing to do with JDeveloper or ADF. Please post your question in a forum dedicated for the product you are using. May be ?

Timo

1 - 1

Post Details

Added on Jun 10 2022
3 comments
662 views