Ingres supports LOB locators in compliance with the ANSI SQL 2003 Standard. LOB locators, which are passed between the client and server, are pointers to the LOB data, which can be stored in or outside a table. They permit the client to access LOB data outside the scope of row data retrieval, so that the client can control the processing and storage requirement of the LOB data.

LOB locators are supported in Ingres JDBC. For more information, see the Connectivity Guide and the OpenAPI User Guide.