Page 1 of 1

Oracle Change notifications

Posted: Tue 25 May 2010 11:30
by jomaa
Hello,

can i use the feature 'Oracle Change notifications' from Oracle dot.Connect in dotConnect Universal? There is a similar function in SQL Server and postgreSQL, can i use this also?

Perhaps you have any sample code?

Posted: Tue 25 May 2010 16:57
by StanislavK
dotConnect Universal provides main ADO.NET functionality for each bundled data provider. Thus the features that can be used via the general ADO.NET methods will be available in dotConnect Universal; the database-specific features that are implemented via special components are unavailable.

Speaking about Oracle change notifications, what exact feature do you mean? Is it the functionality that is provided by the OracleDependency class or, maybe, the OracleAlerts functionality? The first is not available in dotConnect Universal, the latter can be reached by using the DBMS_ALERTS package directly.