Devart Forums

Posted: **Tue 29 Sep 2009 20:26**

I'm using OraChangeNotification connected with TOraQuery.

This code sometimes can cause ORA-29970 exception, but only sometimes...

Code: Select all

OraChangeNotification.Enabled:=False;
OraChangeNotification.RemoveRegistration(Session);

OraQuery.Close

Is it possible to check if specified registration doesn't exists for current Session? How to remove OraChangeNotification registration from Session properly?

Thanks

Posted: **Wed 30 Sep 2009 07:44**

This is an Oracle bug. Sometimes registration of change notification is failed. But error is returned on unregistration. Call the RemoveRegistration method in try..except block to catch the exception.

In the next ODAC build we will not raise any exceptions on unregistration.

Posted: **Wed 30 Sep 2009 08:06**

Thaks for answer.

Is it possible to check current status of OraChangeNotification - to know is it still registered or not? In case if registration is failed try to re-register it...

Posted: **Thu 01 Oct 2009 08:29**

It is not possible because no error is returned on registration.

Devart Forums

OraChangeNotification: ORA-29970

OraChangeNotification: ORA-29970