ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Notifications error "ORA-29973: Unsupported query or operation

Pit MeinlJul 1 2010 — edited Jul 1 2010

I am trying to uses Change Notifications with ODP.NET and get the error ORA-29973.
I am using:
VS 2010. .NET Framework 4, Windows 7 x64
ODP.NET Version ODAC112011beta

dim cnx As New OracleConnection("DATA SOURCE=ORCL;DBA PRIVILEGE=SYSDBA;USER ID=SYS;PASSWORD=xxx;")
cnx.Open()
Dim cmd As New OracleCommand("select deptno from scott.emp where deptno < 20", cnx)
OracleDependency.Port = 1200
_dep = New OracleDependency(cmd)
_dep.QueryBasedNotification = True
cmd.Notification.IsNotifiedOnce = False
cmd.ExecuteNonQuery()

I did grant Change Notification to user sys. Strangely revokint this right does not result in a different error message.

The following Oracle example throws the same exception:
http://www.oracle.com/technology/obe/hol08/dotnet/changenotification/odpnetchg_otn.htm

What am I doing wrong?

This post has been answered by gdarling - oracle on Jul 1 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 29 2010

Added on Jul 1 2010

#odp-net

1 comment

1,997 views