Forum Stats

  • 3,817,367 Users
  • 2,259,322 Discussions
  • 7,893,760 Comments

Discussions

Export and Import ORDS

Mohammad Shaddad
Mohammad Shaddad Member Posts: 129 Blue Ribbon

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 ...

Tagged:
Olafur T

Best Answer

Answers