Error-38824 Reason:
During the deployment activity for production objects on the UAT environment of an OCI container database, while executing Oracle packages and DB scripts. we encountered an error message: “ORA-38824: A CREATE OR REPLACE Command May not Change the EDITIONABLE Property of an Existing Object.”
On the development environment, we are using a database without a container, while on the deployment side, there is a container database, which has a different structure. The error message “ORA-38824: A CREATE OR REPLACE Command May not Change the EDITIONABLE Property of an Existing Object” indicates that the editionable parameter for objects needs to be set at the database level.
Solution for Error-38824:
We tried to Alter packages permissions on container database with below query.
ALTER USER edition_test1 ENABLE EDITIONS;
Where User edition_test1 can be any package/procedure. We were facing issue while executing package over container database But we resolved the same issue as following query.
ALTER package Name? noneditionable;
As we applied above command then issue was resolved ORA-38824. Hope this can be very helpful for all of you. Enjoy
