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

Purpose

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.

Scope

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

Details

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