Oracle journalling package
A package released under a BSD-style license that implements full journalling. Latest upload was done on 2011-10-07.
Download package source code from here.
The following table tests the data types that are known to be supported.
create table column_types ( int_col integer, number_col number, fixed_number_col number(10,4), varchar2_col varchar2(50), date_col date, timestamp_col timestamp, clob_col clob, blob_col blob, raw_col raw(16) );
Generate journal table and corresponding triggers by running this anonymous PL/SQL block.
begin bcf$utl_journalling.create_journal_table('COLUMN_TYPES'); bcf$utl_journalling.update_journal_triggers('COLUMN_TYPES'); end;
Remember to also alter the JN$... tables whenever you alter the original tables and then re-run
begin bcf$utl_journalling.update_journal_triggers('COLUMN_TYPES'); end;
to ensure that the new or modified columns are being journalled.