Overview

The DBMS_LOB package reads and modifies binary large objects (BLOBs) and character large objects (CLOBs). It provides most of the large object (LOB) operations.

Privileges

This package must be created under the SYS user. However, the operations that the package provides are performed by the current caller, instead of the SYS user.

DBMS_LOB subprograms called from an anonymous procedural language (PL) block are executed with privileges of the current user, whereas DBMS_LOB subprograms called from a stored procedure are executed with privileges of the owner of the stored procedure.

When you create a subprogram, you can set the AUTHID parameter to specify whether the authorization of the subprogram definer or the caller is required. Here is an example:

CREATE PROCEDURE proc1 AUTHID DEFINER ...

or

CREATE PROCEDURE proc1 AUTHID CURRENT_USER ...

Data types

Considerations

All DBMS_LOB subprograms rely on the LOB locator to work. For the successful execution of DBMS_LOB subprograms, you must pass a locator that identifies a LOB that already exists in the database tablespace or external file system.

All DBMS_LOB APIs support operations on remote LOB locators. All APIs that take in two locators must have both LOBs collocated in the same database.

Subprograms

The following table describes the DBMS_LOB subprograms supported by the current OceanBase Database version.