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.