Oracle Database Y2K Protection Triggers Generators
I developed PL/SQL code that generates or modifies PL/SQL “BEFORE EACH ROW” triggers to protect database date columns from Y2K non-compliant date input (from all sources) into the database. A function is imbedded in the triggers that uses the “RR” year formatted date conversion. For each table with...
Main Author: | |
---|---|
Language: | unknown |
Published: |
2021
|
Subjects: | |
Online Access: | http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 |
Summary: | I developed PL/SQL code that generates or modifies PL/SQL “BEFORE EACH ROW” triggers to protect database date columns from Y2K non-compliant date input (from all sources) into the database. A function is imbedded in the triggers that uses the “RR” year formatted date conversion. For each table with at least one date column and with INSERT/UPDATE/DELETE trigger(s), my code inserts date conversion code into the existing trigger(s). For INSERT/UPDATE not in a trigger(s), my code creates a trigger for the absent DML command(s). Designed to be: Transferable to other servers with minimum effort; A uniform and consistent problem solution with easy implementation, testing, and configuration management. No need to manually code and edit SQL trigger files: Modifies existing triggers; Creates needed triggers; Self documented (output comments with code); SQL files configuration management ready. Can customize the: Date conversion function; Code modifications for the trigger; Universal lookup/key; . |
---|