A database server helps to streamline the retrieval of LOB values by deciding
to
send a locator in replacement of the LOB value, or the LOB value itself, depending
upon the specific LOB value being retrieved. A threshold value is determined in
a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding
fetch response, and the lengths above are sent as locators in the fetch response.
Indicators are inserted in a fetch parameter of the response to inform the receiving
client the form of retrieval that was used for each requested LOB value being returned.