Controlling REST API Behavior Completely
For complete control over your ORDS REST APIs, create a full set of PL/SQL handlers.
Tip: Your module templates can mix Collection Query and Collection Item GET handlers with PL/SQL handlers for POST, PUT, and DELETE operations. However, the /v1 and /v2 modules show how to manage even the GET handlers using custom PL/SQL when that level of flexibility might be useful to your application.