Delete or Modify Resource Template + Handler with code

John Howard

Hello ORDS gurus,

I have a requirement to automate, as much as possible, the deployment of my ORDS config across a number of environments. To that end I would like to be able to modify or delete a template+handler pair with code rather than interactively with SQL Developer. I am using DEFINE_TEMPLATE and DEFINE_HANDLER to create. I am using ORDS 21.4. 

Looking at the definition of the ORDS package I can't see any obvious way of doing this. There are no procedures for DELETE_HANDLER or DELETE_TEMPLATE. It is clearly possible to do this as you can do it with SQL Developer.

Is there any secret way or can it only be done by clicking through the gui?

Thanks,

John

thatJeffSmith-Oracle

What SQL Developer does is completely re-create the module, without the templates and handlers you have 'deleted.'

If you look at SQL Developer Web, and delete a template of handler, use your browser dev tools to see what's happening under the covers. I think that will be of interest to you.

thatJeffSmith-Oracle

What SQL Developer does is completely re-create the module, without the templates and handlers you have 'deleted.'

If you look at SQL Developer Web, and delete a template of handler, use your browser dev tools to see what's happening under the covers. I think that will be of interest to you.

John Howard

Hi Jeff,

Thanks for responding so quickly!

So to achieve what I want to do I can drop/recreate the module. I did think about that and wondered if it wasn't a bit heavy-handed but if it's what SQL Developer does anyway - then I may as well.

Thanks again,

John