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?

       

      DB:11.2.0.4.0

       

      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)

       

      SELECT NAME
            ,Uri_Prefix
            ,Uri_Template
            ,Method
            ,Source_Type
            ,SOURCE
        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 ...