SAP DB LOCATOR ABEXA documentation, setup help and example usage

ARTICLE

Locator , Access to Column Content
The example demonstrates how to access texts in the database by using locators .

ABAP_SOURCE_CODE
ABAP_EXEC

ABAP_DESCRIPTION
In this example, the text column of a database table in which texts from the Online Text Repository ( OTR ) are stored in a column of the type STRING , is accessed in a SELECT loop using locators which were created there.
The methods of the locators allow you to get information about the texts without them having to be transported into the ABAP program. In the example, the average length of all texts of a language is determined and the number of texts which contain a specific character string is returned.
Since the number of locators in each database LUW is limited, the
locator created there must be closed explicitly at the end of each SELECT loop. The runtime error DBIF_RSQL_TOO_MANY_LOB_HANDLES
occurs if the maximum number of open locators is exceeded.