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

thatJeffSmith-Oracle

yes

https://www.thatjeffsmith.com/archive/2018/12/how-to-export-your-restful-services/

SET long 5000

SET pagesize 1000

SELECT ORDS_METADATA.ords_export.export_module(p_module_name=>'ora_magazine')

FROM dual;

thatJeffSmith-Oracle

yes

https://www.thatjeffsmith.com/archive/2018/12/how-to-export-your-restful-services/

SET long 5000

SET pagesize 1000

SELECT ORDS_METADATA.ords_export.export_module(p_module_name=>'ora_magazine')

FROM dual;