3 Replies Latest reply on Jul 10, 2020 7:37 AM by 4285098

    How to make sure ORDS is ready to use ?

    4285098

      Hello !

       

      I am having trouble using ORDS. First of all I am not the administrator of the database and of the WebLogicServer so I haven't installed ORDS myself but I assume the tool is correctly installed for several reasons :

      - I can see various ORDS related users when I query "select * from ALL_USERS;" like ORDS_PUBLIC_USER or ORDS_METADATA

      - I can use ORDS' related wizards in SQL Developer

      - PL/SQL procedures automatically generated like this one compile:

      "DECLARE

        PRAGMA AUTONOMOUS_TRANSACTION;

      BEGIN

          ORDS.ENABLE_SCHEMA(p_enabled => TRUE,

                             p_schema => 'RECYCLING',

                             p_url_mapping_type => 'BASE_PATH',

                             p_url_mapping_pattern => 'recycling',

                             p_auto_rest_auth => FALSE);

          commit;"

      END;

       

      - I read on Oracle website that ORDS is already present on Cloud Databases

       

      But I can't make it work so maybe it is not ready to use. (Or maybe I didn't use it correctly but I would rather make sur about install before trying to troubleshoot)

       

      Is it enough to assume the tool is correctly configured and ready to use ? How can I make sure ORDS is ready to use (DB and server's admins take very long to answer so i'd rather not ask them but if I had to, what should i ask them ?)

       

      Thanks in advance and sorry if it seems really newbie but I am new to programming and honestly trying my best.