Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

DBMS_CHANGE_NOTIFICATION - Register queries and receive notifications of changes to the objects they reference.



Noa said...

Thank you very much.

an excellent example


JSung said...

I realise this article is filed under 10g .
A small note that 11g will only show
one table registered.

REGID TABLE_NAME CALLBACK
---------- -------------------- ----------------------------------------
1 TEST.T2 plsql://tables_changed_chnt?PR=0

This is expected and documented in bug 12419297.
The FK related table behaviour is only in 10g.

Praveen said...

Very nice and useful.
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired