Oracle database change notification with ODP.NET doesn't work

Question

I'm complete newbie to Oracle DB trying to enable DB change notifications.

private void RegisterNotification()
    {
        const string connstring = "Data Source=ORA_DB;User Id=USER;Password=pass;";
        try
        {
            var connObj = new OracleConnection(connstring);
            connObj.Open();
            var cmdObj = connObj.CreateCommand();
            cmdObj.CommandText = "SELECT * FROM MYTABLE";
            var dep = new OracleDependency(cmdObj);
            dep.QueryBasedNotification = false;
            dep.OnChange += new OnChangeEventHandler(OnNotificationReceived);
            cmdObj.ExecuteNonQuery();
            connObj.Close();
            connObj.Dispose();
            connObj = null;
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
    }

public static void OnNotificationReceived(object src, OracleNotificationEventArgs arg)
    {
        MessageBox.Show("Table has changed!");
    }

I've executed "GRANT CHANGE NOTIFICATION TO USER;" but nothing happens when I change the table data neither manually nor programmatically. Query-based notifications also don't work. I suppose I miss something in Oracle configuration.

I have Oracle 11.2 standard edition.

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

The CHANGE NOTIFICATION permission is not on the features of the Standard Edition for latest versions : Licensing information

Oracle TimesTen Application-Tier Database Cache :

Data access using PL/SQL, JDBC, ODBC, ttClasses, OCI, and Pro*C/C++

interfaces Transaction Log API (XLA) for change notification

Multi-node Cache Grid

...

SE2 : N

EE : Y (extra-cost option)

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 2, 2019 at 6:21

Joffrey Schmitz

2,4483 gold badges24 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexander Tokarev · Accepted Answer · 2013-06-27 08:42:36Z

0

Try to execute your soft under admin permission and as console application. when we used to deal with it we faced with the same stuff. we hadn't managed to use it in webservices.

answered Jun 27, 2013 at 8:42

Alexander Tokarev

1,0559 silver badges16 bronze badges

Collectives™ on Stack Overflow

Oracle database change notification with ODP.NET doesn't work

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related