An example of the preconditions required in order to run the DatabaseChangeListenerInOracleDatabaseExample.groovy script.

DatabaseChangeListenerInOracleDatabaseSQLExample.sql

--
-- This is required otherwise notifications won't be sent to the JDBC driver.
--
grant change notification to system;

commit;

CREATE TABLE example(
  example_id NUMBER(10) PRIMARY KEY,
  phrase VARCHAR2(120) NOT NULL
);

commit;

insert into example values (1, 'one');
insert into example values (2, 'two');
insert into example values (3, 'three');
insert into example values (4, 'four');
insert into example values (5, 'five');
commit;

--
-- Then once the DatabaseChangeListenerInOracleDatabaseExample.groovy is running
-- execute the following and an update should appear in the Groovy console:
--
update example set phrase = 'one / 1' where example_id = 1;