In the ORDS 18.3 Release notes you'll find this paragraph:
RESTful Services Pre-Hook Function
ORDS 18.3.0 introduces the ability for a stored function to be invoked prior to the dispatching of an ORDS based RESTful Service. This facility enables customers to perform additional request validation and authorization and/or configure the database session as required. In addition this facility provides a means for the pre-hook to assert the identity and roles of the user making the request, thus facilitating integration with custom authentication mechanisms.
You can learn more about this feature in the tutorial located here.
I would like to use this feature but can find no mention of this Pre-Hook feature anywhere except the 18.3 release notes. It is not in the 18.3 Documentation that I could find.
The link "tutorial located here" mentioned in the preceding paragraph doesn't exist.
I have googled and found nothing except the 18.3 release notes page.
I have steered away from enabled objects because we have a multi-tenant database. Therefore, I either needed to alter all the procedures and functions I plan to rest-enable to take more parameters and add pre-processing to validate user and restrict access before accessing code that normally is only available for a user's db session for which she/he has logged into. I've resorted to generating my own module/template/handler/parameters to wrap the stored packages/procedures/functions I publish as REST through ORDS. Yes, I have this working, but I would much rather use the AUTO PL/.SQL if I can inject a stored procedure that will do my session validation and setup without having to modify the objects I am exposing as REST endpoints.
So, my question is:
1. Can anyone offer information on how to use the new PRE-HOOK feature?
Thanks
Mark Wiseman