Skip to content

ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Streaming and Locators 

LOB Interfaces

ABAP SQL supports access to LOBs using streams and locators. For similar reads on these streams and locators, there are the interfaces


which both include the superordinate interface


which then also includes the interface IF_ABAP_CLOSE_RESOURCE.

The connection to streams and locators is as follows:

  • The system classes CL_ABAP_DB_C_READER and CL_ABAP_DB_C_LOCATOR both implement the interface IF_ABAP_DB_CLOB_HANDLE.
  • The system classes CL_ABAP_DB_X_READER and CL_ABAP_DB_X_LOCATOR both implement the interface IF_ABAP_DB_BLOB_HANDLE.
  • The interface IF_ABAP_DB_READER includes IF_ABAP_DB_LOB_HANDLE.

The instances of the system classes that implement the interface IF_ABAP_DB_LOB_HANDLE are called LOB handles.

Other versions: 7.31 | 7.40 | 7.54


The LOB interfaces shown here can only be used for reads. Reference variables for LOB handles that are specified as read targets of the INTO clause in the SELECT statement can be typed statically using these interfaces. The class used to create the object must then be specified using the special addition CREATING in the statement SELECT. For writes with the statements INSERT, UPDATE, or MODIFY, the reference variables which are used as a source must be typed using the classes for writer streams or locators.