Inserting One or More LOB Values into a Row

Figure 10-11 Three Ways of Inserting LOB Values into a Row

Text description of the illustration adl10ps4.gif

See: "Use Case Model: Internal Persistent LOBs Operations", for all Internal Persistent LOB operations.

There are three ways to insert LOB values into a row:

1. LOBs can be inserted into a row by first initializing a locator -- see Inserting a LOB Value using EMPTY_CLOB() or EMPTY_BLOB()

2. LOBs can be inserted by selecting a row from another table-- see Inserting a Row by Selecting a LOB From Another Table.

3. LOBs can be inserted by first initializing a LOB locator bind variable -- see Inserting a Row by Initializing a LOB Locator Bind Variable.

Usage Notes

Here are some guidelines for inserting LOBs:

Inserting LOBs For Binds of More Than 4,000 Bytes

For guidelines on how to INSERT into a LOB when binds of more than 4,000 bytes are involved, see the following sections in Chapter 7, "Modeling and Design":

• Binds Greater than 4,000 Bytes are Now Allowed For LOB INSERTs and UPDATEs

• Binds of More Than 4,000 Bytes ... No HEX to RAW or RAW to HEX Conversion

• Example: PL/SQL - Using Binds of More Than 4,000 Bytes in INSERT and UPDATE

• Example: PL/SQL - Binds of More Than 4,000 Bytes -- Inserts Not Supported Because Hex to Raw/Raw to Hex Conversion is Not Supported

• Example: PL/SQL - 4,000 Byte Result Limit in Binds of More than 4,000 Bytes When Data Includes SQL Operator