Using the DBMS_LOB Package
There are many built-in packages provided by Oracle. These are often wrapped procedures. You can’t seethe 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. CLOB and BFILE columns are added to the PRESIDENT table to support the OCI-Lob object discussion.
This section is divided into three subsections:
Verifying or ...