Thursday, January 12, 2017

How to solve pluggable problem in 'Continuous Query Notification'?

A required feature for CQN registration of store procedure is that the database where is creating objects should be not pluggable an error will appear like below:

65131. 00000 -  "The feature %s is not supported in a pluggable database."
*Cause:    An attempt was made to use a feature that is not supported in a
           pluggable database.
*Action:   Do not use this feature in a pluggable database.

The solution is to create a new database with not PDB configurate that make enable pluggable parameter not appear in ora file.

Another problem is when you are doing a registration of a store procedure via CQN a problem will occur with other DML executed after by CQN registration, the error will be as the follow text:

ORA-29973: Unsupported query or operation during change notification registration


Important links: