Hi All!
I have followed the lab series about ORDS, e.g. Lab 3: REST Development using Oracle SQL Developer
https://apexapps.oracle.com/pls/apex/f?p=44785:24:104435224752480:::24:P24_CONTENT_ID,P24_PREV_PAGE:13286,24
- i.e. using Oracle SQL Developer GUI I have created ORDS Modules, Templates, etc.
Question: How to export all these ORDS objects to script that looks like this:
ORDS.DEFINE_MODULE (...)
ORDS.DEFINE_TEMPLATE (...)
(...)
- in order to create patch and push it to test ... prod environments, where it could be just run from sqlplus?
Or, if that can't be achieved - what is recommended approach to push ORDS objects to test ... prod environments?
Thanks in advance!
--
Question 2:
Is there a comlete set of steps which Administrator manually / DevOps pipeline automatically should perform one/every time we need to change something in ORDS on test ... prod environment?
for example:
I. One time - Admin - manually:
1) Install & confilgure ORDS: manual here: URL xxx
2) nothing else!
II. Every time for every patch - Admin - manually:
1) ...
III. Every time for every patch - DevOps pipeline automatically:
1) run sqlplus with script containing chsnges in ORDS objects:
ORDS.DEFINE_MODULE (...)
ORDS.DEFINE_TEMPLATE (...)