Donate Share

cx_Oracle

Email Archive: cx-oracle-users (read-only)

[cx-oracle-users] Database change notification
From: Anthony Tuininga <anthony.tuininga@gm...> - 2009-01-08 15:42
All,

I have just committed to Subversion code that add support for database
change notification in cx_Oracle. This feature adds support for a
callback being made by Oracle when rows are inserted, updated or
deleted in queries that are of interest and is available in Oracle 10g
Release 2 and higher. In particular this is useful for keeping caches
up to date. You can see more about database change notification here:

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm

There is a sample script in the samples directory called
"DatabaseChangeNotification.py" that demonstrates its use in
cx_Oracle.

I'd appreciate any feedback any of you might have. I'll likely release
this code and a couple of bug fixes I've made sometime next week --
but I'd prefer to know if any changes would be desirable before that
time, of course. :-)

Anthony

 

Thread View

Thread Author Date
[cx-oracle-users] Database change notification Anthony Tuininga <anthony.tuininga@gm...>