Currently when logging transactions with ORDS we access the data of the service being called via OWA_UTIL.GET_CGI_ENV.
This turned out to be an issue when analyzing service requests later on since a service URI could have a bind variable inside the URI. It would be very helpful if we had access to the pattern.
ORDS does already provide useful bind variables like: :current_user and :content_type.
Is there any bind variable that identifies the URI pattern of the template being used?
Is there any bind varabile that identifies the service being called?
We use ORDS handlers of source_type plsql/block only.
Currently our solution would be to pass the module name and pattern to the function/procedure inside the ORDS handler manually.
p_module_name => 'shop', p_pattern => 'order/:orderid', p_method => 'GET',
p_source_type => 'plsql/block',
p_source => 'DECLARE
shop.order.getorder(poauthclient => :current_user, porderid=> :orderid, puripattern => ''GET shop/order/:orderid'');
p_items_per_page => NULL
It would be big help if the declare block had access to the module name, the pattern and the method via bind variable or at least deliver any ID that would give use access to the pattern.
No, we don't have a special bind variable for this. File an enhancement request.