Autonomous Transaction Processing

Get Involved. Join the Conversation.

Topic

    sergey opariy
    DRCP in Autonomous Transaction Processing
    Topic posted February 4, 2019 by sergey opariy, tagged Transaction Processing 
    155 Views, 2 Comments
    Title:
    DRCP in Autonomous Transaction Processing
    Summary:
    DBMS_CONNECTION_POOL in Autonomous Transaction Processing
    Content:

    Is DRCP available in ATP 18.4.0.0? I tried to start it as ADMIN with the following result:

    SQL> EXECUTE DBMS_CONNECTION_POOL.START_POOL();
    BEGIN DBMS_CONNECTION_POOL.START_POOL(); END;

          *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DBMS_CONNECTION_POOL.START_POOL' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

     

    DBMS_CONNECTION_POOL has to be started as SYS. How I can start using it in ATP

    Thank you 

    Version:
    18.4.0.0

    Comment

     

    • Robert Greene

      DRCP is not supported with Autonomous Transaction Processing.   There is currently no roadmap to enable.    

    • Maria Colgan

      I've filed a doc bug to make sure the restriction on DRCP is documented in the Appendix Autonomous Transaction Processing for Experienced Oracle Database Users going forward.