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:

• http://oraerrormsgs.blogspot.mx/2012/05/ora-29973-unsupported-query-or.html
• http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_cqnotif.htm#CIHBBFDD
• https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm#BGBGAGEF
• https://jsao.io/2015/02/real-time-data-with-node-js-socket-io-and-oracle-database/
• http://stackoverflow.com/questions/33388155/alternatives-for-continuous-query-notifications-in-oracle-12c-cdb-pdb-setup
• https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9522537800346597791
• https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11g-xe/