Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete or Modify Resource Template + Handler with code

John HowardAug 8 2022

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

This post has been answered by thatJeffSmith-Oracle on Aug 8 2022
Jump to Answer

Comments

Processing

Post Details

Added on Aug 8 2022
2 comments
704 views