Skip to Main Content
Feature Request FR-4505
Product Area Application Builder
Status CLOSED

7 Voters

APEX Working Copy Should Track or Notify DB Changes

neel.shah18 Public · Jun 11 2025

In Oracle APEX, the Working Copy feature lets developers make changes safely. However, if the underlying database objects (tables, views, procedures, etc.) are modified during this time, the Working Copy is unaware. This can lead to issues when the changes are published.

Use Case

  • Alert developers if related DB objects change during Working Copy edits
  • Avoid publishing outdated logic tied to modified database structures
  • Improve collaboration between APEX developers and DB teams

Preferred Solution

Add a mechanism to either:

  • Track schema changes for DB objects used in the app, or
  • Notify developers when changes occur while a Working Copy is active
We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is not feasible in APEX.

Comments

Comments

  • akmo OP 5 months ago

    This will be a very helpful and useful option.

  • vincent morneau Admin OP 5 months ago

    The team discussed this idea today. We think it's unfeasible without some sort of DDL triggers, which we would prefer to avoid. I understand the requirement, but I don't think we can action this for now.