1 Reply Latest reply: Oct 26, 2012 4:10 PM by Mark Williams-Oracle RSS

    Dependency/Notification & bulk commits.

      I observed that the OracleDependancy notification do not return all rows(RowId) affected by dml statements like 'Update myTable set myField = 'Myvalue' where id < 1000'
      The RowID column is empty in this case.
      Is this by design ?, is there any work around to get all updates ?
        • 1. Re: Dependency/Notification & bulk commits.
          Mark Williams-Oracle
          Are both client and server at least version 11.1?

          Have you taken a look at the Database Change Notification Support section in the Oracle Data Provider for .NET documentation?


          Also, see the following discussion (Using Continuous Query Notification (CQN)) from the database docs:


          From the ROWID Option section:

          "Too many rows were changed in a single registered object within a transaction (the upper limit is approximately 80)."

          [ link accurate as of posting ]

          Edited by: Mark Williams on Oct 26, 2012 5:07 PM