My Oracle Support Banner

Example of Edition-Based Redefinition using Cross-Edition Triggers (Doc ID 845667.1)

Last updated on JANUARY 29, 2022

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.


This document provides a complete reproducible example of Edition-Based Redefinition based on the code samples provided in the Edition-Based Redefinition chapter of the Advanced PLSQL Programmers Guide.

It is split up into 5 logical steps with explanatory notes included in the code.

Note that this example does not execute the final steps to implement the pipe as the default, since this part of the process is irreversible.


This document is intended for any developer investigating the functionality of Edition-Based redefinition
and wanting something that they can use as a basis for testing the functionality


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1.  Set Up Test Data
 2.  Prepare The Application For Editioning
 3.  Create a New Edition and Modify The Application
 4.  Define Cross-Edition Triggers and Migrate the Data.
 5. Run Some Tests

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.