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 ...

Get Oracle Database Ajax & PHP Web Application Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.