Using the DBMS_LOB Package
Oracle provides many built-in packages. These are often wrapped procedures. You can’t see the implementation details of wrapped packages. An example of a wrapped package is the DBMS_OUTPUT package, which has been used to redirect standard out from the PL/SQL environment to the SQL*Plus console. There are many more built-in packages that you can find in the PL/SQL Packages and Types Reference 10g Release 2.
This section reviews the basics of the DBMS_LOB package and supports how you use the DBMS_LOB package in conjunction with Oracle LOB data types covered in Chapter 15. CLOB and BFILE columns are added to the PRESIDENT table to support the OCI-Lob object discussion in Chapter 15.
This section is divided into three ...