OraChangeNotification: ORA-29970

Equites · Post by **Equites** » 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

Plash · Post by **Plash** » 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.

Equites · Post by **Equites** » 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...

Plash · Post by **Plash** » Thu 01 Oct 2009 08:29

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