Hi,
I am using Oracle Apex as an Database application, Bitbucket as Source Control and Jenkins for CI/CD.
The case here is that i dont want developers to login to APEX and make the procedure/package changes. I want them to edit it using a tool like PL/SQL developer tool and whenever a package/procedure is updated by any developer then Jenkins should create a build for it and compile and execute on the DB Server.
This way i can restrict the APEX changes and also setup testing automation whenever something is updated in APEX.
Can you please help me out to create a flow for this case, suggest plugins/tools to implement this.
Any other idea to support this case is highly appreciated.
Oracle Version- 11.2.0.4
APEX-4.2.6
Regards,
Bhavin