Autonomous Transaction Processing

Get Involved. Join the Conversation.

Topic

    Ludovic DESSEMON
    ATP and Continuous Query Notification (CQN)
    Topic posted April 30, 2019 by Ludovic DESSEMON 
    72 Views, 2 Comments
    Title:
    ATP and Continuous Query Notification (CQN)
    Content:

    Hi, does ATP supports Continuous Query Notification ? I would like to use CQN with Nodejs (node-oracledb) in order to track some changes in ATP

    Comment

     

    • Joel Grocock

      Hi Ludovic,

       Although CQN is not explicitly listed as a restricted or removed Oracle feature in ATP I have tried to follow this example with the SH user and I'm not sure if DBMS_CQ_NOTIFICATION available. I could just be having a bad morning ;-)

      Hopefully Robert or Maria can comment.

      Regards

      Joel

       

       

    • Ludovic DESSEMON

      Thanks Joel

      I've just created an ATP instance and DBMS_CQ_NOTIFICATION seems not being available (connected as Admin user):

      Error starting at line : 2 in command -
      GRANT EXECUTE ON DBMS_CQ_NOTIFICATION TO ludo
      Error report -
      ORA-00942: table or view does not exist
      00942. 00000 -  "table or view does not exist"
      *Cause:    
      *Action:
       
      Customers are not given OS logons or SYSDBA privileges : Without the SYSDBA privilege it is not possible to grant execute on DBMS_CQ_NOTIFICATION. How to proceed on ATP ?