1 Reply Latest reply on May 20, 2020 6:09 PM by thatJeffSmith-Oracle

    Export and Import ORDS

    Mohammad Shaddad

      Hi All

      Kindly, I have get and post ORDS web service, is there is a SQL script to extract all web service source code (DML) so I can extract and execute in another database?




      I found this simple SQL but it's showing only the trigger procedure not the full code which I used when I create the web service (ex: enable_schema, define_module, define_template, define_handler and define_parameter)


        FROM User_Ords_Modules   a
            ,User_Ords_Templates b
            ,User_Ords_Handlers  c
       WHERE a.Id = b.Module_Id
         AND b.Id = c.Template_Id


      Thanks ...