DBMS_LOB

This package provides procedures to work with BLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBs.

Procedures

The most relevant procedures are:

• GET_LENGTH: gets the length of the LOB value

• FILEOPEN : opens a file

• LOADFROMFILE : loads LOB data from a file

• APPEND : appends the contents of a source LOB to a destination LOB

• OPEN : opens an LOB

• READ : reads data from the LOB starting at the specified offset

• WRITE : writes data to the LOB from a specified offset

• CLOSE : closes a previously opened LOB