ORDS query with parameters code example

Example: ORDS send to endpoint

BEGIN
  ORDS.DEFINE_PARAMETER(
    p_module_name => 'module_ws',
    p_pattern => 'bookings/',
    p_method => 'DELETE',
    p_name => 'X-APEX-STATUS-CODE',
    p_bind_variable_name => 'status',
    p_source_type => 'HEADER',
    p_access_method => 'OUT'
  );
COMMIT;
END;