Example of Edition-Based Redefinition using Cross-Edition Triggers
(Doc ID 845667.1)
Last updated on JANUARY 16, 2020
PL/SQL - Version 188.8.131.52 and later Information in this document applies to any platform.
***Checked for relevance on 12th Feb 2018***
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!