Ansicht
Dokumentation

ABENDB_LOCATOR_ABEXA - DB LOCATOR ABEXA

- Locator, Access to Column Content

This example demonstrates how to access texts in DDIC database tables using locators.

Source Code

Execute

Description

In this example, a SELECT loop and locators created there are used to access the text column of a DDIC database table in which texts from Online Text Repository (OTR) are stored in a column of the type STRING.

The methods of the locators make it possible to get information about the texts without them having to be transported into the ABAP program. In this 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.